Summary Sheet based on selected date

[pmallick]

Hello,

I am looking for a way to coalate certain data from all worksheets in my workbook in one summary sheet based on a user inputted date.

The workbook will grow with additional sheets added at irregular intervals.
Each worksheet has the same layout, just with different data.
I want a user to input a date in cell B2.
Then i want the vba to look that value up in all other sheets and copy data from adjacent cells.

I have attached a sample workbook.

Thanks in advance for any help you may be able to provide.

PaulineProject Plans - Sample.xlsm

[karedog]

Hi,

You can try this code :

Please Login or Register  to view this content.

Regards