Excel Nub Help

Zenduri · 30 Jan 2017 at 19:09

I'm very poor with excel in general and I'm trying to teach myself how to use VBA and macros etc etc etc by using working examples but i need a bit of help.

I need to create a drop down where dependent on selecting a certain option from the drop down it pulls input fields from another sheet.

Eg i have a drop down which has the options "Request to" and "Request From"

If i select "Request To" it pulls through a series of cells from another sheet which would be Sender ID, Recipient ID, Request flow, Date, SLA which also pulls through a series of blank cells under each column

By selecting "Request From" it pulls through a series of cells from another sheet which would be Sender ID, Request flow, Allocation Date SLA Cutoff

Underneath each populated cell I would input information and then submit this to write back to another sheet but i don't know what to do re the lookup for which cells it pulls through based on the drop down.

i hope this makes some sense other than utter ramblings.

Below is kind of how I was hoping it to show once each option is selected from the drop down.

Imgur Snippet

Zenduri · 30 Jan 2017 at 20:44

Additional:

currently im using =VLOOKUP(VLOOKUP(D3,Sheet4!A5:A13,1, FALSE),Sheet4!A5:I13,3, FALSE)

So when selecting the option from the dropdown list it also searches for the relevant fields on the related lines from the datasheet. it works but it returns "0" if there is nothing in that field. is there any way to hide it or make it return a blank

FunkyCowie · 4 Feb 2017 at 13:49

=VLOOKUP(VLOOKUP(D3,Sheet4!A5:A13,1,""),Sheet4!A5:I13,3,"")

or you can set that sheet to never show zero's in the settings... excel options > advanced > display options for this worksheet > uncheck the box for show zero in cells that have zero value.

FunkyCowie · 4 Feb 2017 at 23:34

For your other problem that could be as simple as you have one sheet for Request To and one for Request From that way you have no faffing with formula... however if you want to do it as a formula it can be done with simple IF statements with the two conditions from the drop down. Once your form is filled out I take it you are using a macro to to copy the information to another sheet to use as a database for the transactions and sending an email?