Problem with macro to automate copying data from one column to another.

[Arty_1]

Hello!

I'm handling huge information blocks (schedules, tables etc.)

Unfortunately I've encountered an issue concerning manual copying data from one column to onother.

Would you please be so kind as to help me with an advice -

how to automate copying the values from column A to B,

at that moment, when any value of column "A'' changes.

Consequently when any of column's "A" values changes, all the "A" column's values are copied to column "B"

There should be only values pasted in column "B", without any interrelation.

I've attached a xlsx file with more detailed description.

I'll really appreciate your cooperation

[AB33]

The code resides in sheet1 and fires on by changing any value in column A.

[Arty_1]

Thanks a lot!

It's working great!

Unfortunately I cannot find any code in macros options (I'd like to copy it to another worksheet),

could you please send it?

[AB33]

The code is on sheet1. The code should not reside on module. Right click on sheet1, then view code, copy the code and paste in to sheet where you are making and copying changes.

[RudiS]

Hi,

Here is AB33's macro:

Please Login or Register  to view this content.

Note that it is an event macro, so you must follow these instructions to paste it properly.

1. Copy the macro above
2. Open the workbook where you need the macro
3. Right click on the sheet tab in which the macro must run
4. Choose View Code
5. When the VBA editor opens, right click on the module and paste.
6. Close the VBA editor

The macro should now run for this sheet too...

[Arty_1]

Glad to see You, Rudi!

It's working excellent!

Thank you for the detailed explanation!

[Arty_1]

Two more additional questions:

How do I edit the code if:

1. The copied range is going to be the whole column "F" which is going to pasted in the column "G"

2. The the copied range is going to be "F2-F50" which is going to pasted in the range "G2-G50"

[RudiS]

Hi,

Using AB33's code as a base, you can change it as follows:

For 1. The copied range is going to be the whole column "F" which is going to pasted in the column "G"

Please Login or Register  to view this content.

And for 2. The the copied range is going to be "F2-F50" which is going to pasted in the range "G2-G50":

Please Login or Register  to view this content.

[Arty_1]

I wish I had the knowledge You have, Rudi!

Macro it's working excellent!

Thank you!

[RudiS]

I had little to do with this one. AB33 did all the work.
Glad it is working for you though. That's the whole reason for this forum...to help others to be more productive.

Cheers
TX AB33. (From me too!)