Get Data via drop down list

[Dibbley247]

Hi guys

I have previously used a get data macro to go and return figures from different spreadsheets to collate in one place. And now I would like to use this again, but in a different way.

Basically, When I hit the button to get the data, It will first look at the dropdown list, and see what day is selected, and return figures for that day only.

Here is what i currently have:

Please Login or Register  to view this content.

This example would be for saturday, so if the dropdown list said "monday" then it will go off and get mondays figures.
I think this would mean a massive list as our days are actually split into day & Night so there would be 14 scenarios.

I'm guessing, it would have to be an IF or an ELSE between each set list??? Then the whole list repeated again?????? but I can't remember how to correctly put the IF or ELSE together for this?

Dropdown list list would contain:

Sat Night
Sun Day
Sun Night
Mon Day
Mon Night
Tues Day
and so on until Sat Day



Many Thanks

[JBeaucaire]

You macro is feeding text strings into your function that it is using to construct accurate formulas. So you should be able to declare a variable to store the sheet name you've selected, then feed that into your text string lists.

Please Login or Register  to view this content.

[Dibbley247]

You macro is feeding text strings into your function that it is using to construct accurate formulas. So you should be able to declare a variable to store the sheet name you've selected, then feed that into your text string lists.

Please Login or Register  to view this content.

Wow! I'll be trying this out within the next couple of days! Thought it was going to be more complicated than that!

Thanks

[Dibbley247]

You macro is feeding text strings into your function that it is using to construct accurate formulas. So you should be able to declare a variable to store the sheet name you've selected, then feed that into your text string lists.

Please Login or Register  to view this content.

Actually, I just realised, there will be a new type of sheet to take the data from for half of this, so the sheet name will always be the same, but the column will change.
E.G Monday is A1 Tuesday is B1. Wednesday is C1 and so on.

So if the drop down said Tuesday, somehow, it needs to know to shuffle over one?

But at the same time as writing this, I am wondering, if I had a lookup hidden elsewhere in the sheet, Monday =A1 Tuesday =B1 then I can use the same method to use the lookup answer for my cell location??

[JBeaucaire]

Yes, you should be able to construct a table that associates text strings with other values. Then do a VLOOKUP on the value in your drop down selection cell.

http://screencast.com/t/ZLust5rhDxSf