Pulling data from a separate sheet by date and sheet title (dynamic)

[Adsup01]

Hello All,

This forum is amazing for helping people like me work through certain challenges.

I am looking to pull data from multiple sheets based on simply inputting a date range into the reference bar and returning certain data to the table on first sheet.

I am currently using a vlookup in the table to pull from sheets..but how do I make the table return data from the date of the sheet input into the reference cells? In other words make the table dynamic to the dates entered in the date rage reference cells.

Example: Reference Cell(s) Date: November 12 2012 to November 20 2012.

I want the table below reference cells (on same sheet) to return certain cell data from the sheets named "November 12 2012" and "November 20 2012" within same workbook.

Any suggestions or help would be greatly appreciated!!

[Naveed Raza]

plz provide some example workbook then its more easy to solve ur query.

[Adsup01]

Thank you for your reply.

Attached is the workbook I am currently using.

Any suggestions would help, thank you!

Group forum example Pick up -.xlsx

[Naveed Raza]

Hi ,

I am working on this very soon i will get back to u.

Have a nice day.

Thanks - Naveed.

[Adsup01]

Thank you very much Naveed. I appreciate your assistance!

[Naveed Raza]

Hi Adsup,

I come back with ur solution below are the some points to follow.

1) In between macro will ask u for No.of rows so in that u need to enter Last Row Number of Lookup Tab means in pick up tab u r looking up from another sheet right from that sheet go and check the what is last row number and enter it ok.

2) In F1 cell enter the 1st tab name and in G1 cell enter the another tab name ok.

3) Next run the Macro u will get the data.

4) This is very important Might b it will take some time if u morethan 1000 rows ok.

if u get anyother solution from any VBA Gurus go head with thr Code.

How Much knowledge i hv in VBA from that level I prepared.

Please have quick Review and let me know if u have any question plz its time for my Sleeping.

Find the attached File.

Thanks - Naveed.

[Adsup01]

I Naveed, thank you. I don't see the attached file though. can you resend when you get a chance?

thank you again.

[Naveed Raza]

Oh sorry I thought file got attached but bcz of huge size its taking time once this attached u will get file. ok

[Adsup01]

Hi Naveed, I don't want to wake your sleep. Let me know if you are able to send that doc/workbook when you can.

Thank you again for your help.