Pull data from worksheet specified in cell

**jimbobakoo** · 04-04-2014, 05:11 AM

I have created a table which retrieves answers from a survey between a certain date range which you can filter by day using the formula:

Formula:

Please Login or Register  to view this content.

The "Results!"tab being the sheet with all the data in, B4 & B5 being the date range and B3 being the day filter. I wish to add 2 new filters but am having ALOT of difficulty.

One would be if a cell contains anything then pull the data from the worksheet specified in that cell (D1) instead of "Results!", the other would only look at records which have the city specified in the cell (D2). The formula must still perform the same as above if both fields are blank.

So far I have:

Formula:

Please Login or Register  to view this content.

However, (although it is unfinished) it seems extremely messy and I don't seem to be progressing with it as I would like, also I have no idea how to retrieve data from a worksheet that is specified in a cell.... would it be something like

Formula:

Please Login or Register  to view this content.

?

I cant attach my file as it is too big to post on this forum, but if you would like to PM me your email address I would be happy to email you a copy of the spreadsheet I am working with.

**aworfolk** · 04-04-2014, 07:59 AM

I am not sur about the first question but if in cell D1 it has the name of the tab you could use

Please Login or Register  to view this content.

What this is doing is looking at these cells pulls the name makes it to a address and then shows the results

D1= Sheet2
E1= A
F1= 1
Sheet2 Cel A1 =1

**jimbobakoo** · 04-04-2014, 08:05 AM

Thanks, that will definitely come in handy at some point, currently I am working with someone else and have found a different way around the problem. But any help is still appreciated.