Hi Everybody,

I hope you can help me. I have a number of worksheets for individual sales people, which consists of their sales figures, and forecast. What I would like to do is copy the tables as they are, formatting etc to a another worksheet, and place them one underneath the other. So when I run the macro for the first worksheet it copies it to worksheet X as it is. Then when I run it on worklsheet 2 it looks for the first availble row, adds one for a space and then copies the table as it is to worksheet X. Repeat as required for the total number of worksheets. If Ic ould do this in a single macro without running it per sheet it would be very helpful as well. The tables are dynamic in their row count, which makes this a bit trickier with other solutions - hence I have posted this on the forum for your help.

Thanks

Compaqact