Macro to copy/paste tables from one worksheet into another

**Coachwooten** · 03-28-2013, 10:24 PM

Hey there all,

I've got a spreadsheet I use to manage the inventory of a small side-business I run. This spreadsheet involves tables across multiple sheets that can vary in size depending on my inventory.

Ultimately, I need to be able to copy/paste these tables (there are 14-15) into a spreadsheet that has a completely different format. I will be using this spreadsheet to copy/paste my inventory into a forum thread - so it needs to list these tables in sequential order with appropriate gaps (2-3 rows) in between each table. I've created a spreadsheet 'shell' that has the titles of each table already in place.

So far I've been able to figure out how I can copy/paste these tables to the clipboard and over to another sheet, even with the changing table sizes - I recorded a macro that can select and copy all the tables using Control + Shift + Down and Right arrow keys. The way I tried to work it was inserting copied cells by the shortcut Control + Shift + "+", then doing Control + Down arrow, Control + Down Arrow, then Down Arrow. This put me in the appropriate cell reference for the next table to be inserted. Sadly, VBA didn't seem to capture these keystrokes, but rather it pasted my clipboard to a specific cell reference (e.g. A264)

Obviously, this macro works fine when the amount of rows in each inventory table don't change. Sadly, they do..

How can I record/write this macro in order to make it work with relative references, etc?

I'm happy to forward this spreadsheet if it would help explain my situation - I know the above was probably hard to follow.

Thanks in advance for all the help!

**zalora** · 03-28-2013, 10:47 PM

Please Login or Register  to view this content.

**Coachwooten** · 03-29-2013, 04:51 AM

Originally Posted by zalora

Please Login or Register  to view this content.

That didn't appear to work for me - If anyone is inclined to help, I'd be more than happy to shoot you an e-mail with this spreadsheet attached. I think it would really help expedite the process since this is a fairly unique workbook structure.