Need macro help

[wilkisa]

Here's the scenario: My user has a workbook with 3 spreadsheets. The DATA sheet contains a series of small tables. Some of the tables are exactly 6 rows long by 6 columns wide (B:G). These tables all have headers in the first cell of the table in column B and they all begin with "Type 3 Ladies Day (something else)". The (something else) refers to a specific name, such as "Hunny Bun", Sweetie Pie", "Dumplin'", etc. All of the names are different lengths but the "Type 3 Ladies Day (" is the same on all headers.

I need to set up a macro to search column B and find/match the Type 3 the return the (something else) information. It needs to then go to the SUMMARY sheet and paste the name into cell B7, which is the first cell of the SUMMARY table.

It then needs to go down the the last row of the 6x6 table and then to the last cell of that table and copy the value in that cell. It should then go to the SUMMARY table and paste the value in the corresponding cell in column I.

This macro needs to search the entire DATA sheet for all TYPE 3 references then stop when all are found.

Can someone help me, please?

Thanks in advance for any help I can get.

 

[wilkisa]

Can anybody help get me started?

Please??