extracting certain cells from multiple worksheets

[safaval1]

Hi,

I was hoping someone can help me with my dilemma. In my department, we use several worksheets that we call trackers. What I want is a macro to start the process by letting me select the date range and then to extract the data from all worksheets to a new worksheet.
The worksheet’s names are as follow:
1. Batch sample
2. Water sample
3. Fruit sample
4. Room Sample
5. Misc. sample

All date ranges are located in column “A” and what I need is if the date matches the selected date, then copy and paste link columns “B” thru “J” .

Thanks,

[pike]

Welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

[Kelshaer]

Use this

Please Login or Register  to view this content.

[safaval1]

Thank you Kelshaer. It worked perfectly. Nice Job.

[Kelshaer]

Please mark the thread as SOLVED.