Macro to make copying cells automate,- an appeal for expert's advice!

Hi!

I've got a problem with copying cells from table A to B.

A short insight of the situation:

Table A shows: ITEM_1 = 3, consequently ITEM_1 from table A is copied to table B for 3 times.

I've got a few huge information blocks to handle (up to 5000 items) obviously it's unreasonable to do this manually.

Would you be so kind as to give the matter a reasonable consideration?

I've added an xlsx file with more detailed description.

Thanks in advance

Lebedev A.

Hi,

Looking into this...

Hi,

Here is a macro to do the task...

Hi,

Here is the code...

Please Login or Register  to view this content.

Hi,

You don't need to edit the macro as it works on the length you make the tables in the sheet. Just extend the codes in columns Q and R to an arbitrary row...
If you have 5000 records in the first table, extend the Q and R column codes down to row 6000 (or even 7000) using autofill. Please note that the macro will only fill to the end of this range, so make sure it is extended far enough. If it is not, the macro stops if it hits the last row in table two.

I'm glad to hear it is working well.