Copy data to another workbook when ANY cell changes

Gene1126

New Member
Joined
Jul 27, 2007
Messages
1
Any way to copy from 1 workbook to another, dissimilar workbook, when ANY cells value, in specific columns, changes in source workbook. Doesn't need to do it as each change occurs but after source workbook is saved or alternatively through a macro that could be run at any time comparing the two worksheets and applying the changes. In addition the column header names are different so a comparision would have to be made first on the source column header and the destination column header.

Thanks in advance for any help.
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,456
Hello Gene1126, welcome to the board.
Yes, that can probably be done. It's just a matter of what all will need to be done and that
will be somewhat dependant on the layout of the two workbooks.
It can be done on demand, automatically before each save of the source Wb or both.
A couple questions are in order though.
You say the workbooks are dissimilar. In what way? - In their content, or just their layout?
For what I'm thinking they can be dissimilar in their content as long as the destinaton Wb
has at least everything the source Wb has, even if in a different layout.
Will the destination Wb always be open when the source is open, or does the code
need to check for (& open if needed) the destination Wb?
The only part of your post that gives cause for concern is:
the column header names are different so a comparision would have to be made first on the source column header and the destination column header.
Unless the columns of interest are the same columns with different headers, how
are we to determine which column (or header) in the source Wb corresponds
with which column or header in the destination Wb?
 

Forum statistics

Threads
1,181,647
Messages
5,931,208
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top