Macro needed to Concatenate Data in separate TABLES

Hello



I would need a macro that can do this show in the file I've attached.
I need a macro needed to concatenate data in separate tables......



Very thanks for help

PLease look at the titles: they are similar but not the same!

Originally Posted by MickG

Try this:-
Results start "F1"

Thank you;
But it seems not works....
I made something wrong?

I open the file and what I have to do?


thanks

Originally Posted by jindon

You should upload the second file in the first place.

Please Login or Register  to view this content.

Yes it Works!

But I would need to undestand what I have to change if the columns are differents;
I look the macro you posted, but I don't understand what i have to change if i change need to change column.....I try to explain me better:

For Ex.
Please see this file attached;

I need that the macro will copy the D column (yellow) of the "second table" in the C column of the "first table" (yellow) -always sorted by ID- leaving totally unaffected all data present in the column of the fisrt table previous and next.
So I need to understand what I have to modify in the macro If I have to copy for ex. column E of "second table" (purple) into column G of "first table"(purple).


Thanks

Someone is able to write me a macro quite simple to edit and change parameters?

Ps. The macro above runs well but I don't know what I have to change if i need to switch ex. To work on purple columns

THANKS FOR HELP

Ok my friend

You asked for a simple macro.

Well this is not simple.

But it will find your two tables in your spreadsheet and merge them into a new table at the bottom.

All you need to make sure is that the top left hand corner of the table contains the word ID.

Please Login or Register  to view this content.

I will look at that for you tomorrow.

But How do I know that the data from table 2 column A needs to go to Table 1 column 1?

Do I need to test to see if it is empty? Or do I assume that it will be empty?

Hello,

But How do I know that the data from table 2 column A needs to go to Table 1 column 1?

Sorry but.....I don't have understood well your question anyway:
The row will be sorted by ID number --- and I decide myself that the data from table 2 column A need to go to Table 1 column 1....

or if It is easyer to code we can do that the data will be copied in the first full white column on the right of the first table or we can do that the columns where the data will be read and copied have the same name; like you prefer.

Do I need to test to see if it is empty? Or do I assume that it will be empty?

It will be ALWAYS empty (no need to do any test to check If It is empty)


Thank you

Try This:

If this meets your requirements we can copy that to a clean sheet and delete the old sheet.