Copy/paste tables from one sheet to another

[Scavenger102]

I have created something similar in the past but not sure how to copy range of x-number tables to another sheet where it would show one combined table.

The spread sheet has unlimited tables (i.e. 1st table - A2:G17, 2nd table - I2:O17, 3rd table Q2:W17 and so on...)

I would like to get all the data in another sheet each one below the previous one (if that makes some sense) so if fact Table 2 - I2:O17 would be just below table one so starting from A18:G33 and the same with every next table with data. Otherwise I need to copy and paste manually and it might be many tables imported in this sheet from the software (to which I have no access).

The similar macro that I have created in the past was as below but I have no clue where to start here as the old one was moving the whole line and this one must check whether there is more tables to be copied and paste to another sheet. It was also moving just one line and I want to move the whole table now:

Please Login or Register  to view this content.

[Richard Buttrey]

Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Scavenger102]

Now done, thank you Richard

[xlnitwit]

Hi,

Is your real data actually set up as Tables, or simply normal ranges? The former would be much much simpler.

[Scavenger102]

Hi

It is real data that is being sent to me daily in the format as saved in excel file that I have attached. The X's are real data which I can not show. I agree that the former would be much easier but the task is to create a VBA that would do as stated above.

[xlnitwit]

Assuming the tables are always 1 column apart as in your example, perhaps this

Please Login or Register  to view this content.

[Scavenger102]

Thank you, that's exactly what I was looking for

[xlnitwit]

You're welcome. Please remember to mark the thread Solved using the Thread Tools link at the top of the page.