Finding 3 tables on a sheet and copying them, and then removing the blanks

**the00** · 02-13-2012, 08:08 AM

Hi all.

I have used this forum a few times to search for solutions to my problems. This has taught to start using macros, but I'm a bit unsure with this one...

What I want to do is have a macro which finds a table on a sheet, and then copy the data from that table to a different workbook.

I have done the copying, navigating and and pasting before, but I don't know how to search / find the start and end point of the range of the table.

The table will always ahve the same layout, same column headers for example, but there will be a different number of rows each time. However, there will always be the same text at the bottom of the table, so maybe I could search for that and offset???

Thx.

**arlu1201** · 02-13-2012, 08:13 AM

Its better if you attach a sample file to this thread. It will help us to understand your tables.

**the00** · 02-13-2012, 08:54 AM

Ok, attached is a sample file.
There will be a sheet for each day of the week.
Each sheet will have the three tables as shown, but with different numbers of rows depending upon the workbook. I want to copy the top portion,above the 'waste watch' cell.
You can see the common text at the bottom, although the table will not be completed this far...