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???