Data Replication

Example: On Sheet1, I have columns A, B & C with data. On Sheet2, I'd like to replicate only columns B & C from Sheet1 without manually copying and pasting and without making every cell on Sheet2 equal Sheet1. Is there any way to achieve this? When new data is entered on Sheet1, it should auto update on Sheet2 as well.

I know I can achieve this by making every cell on Sheet2 equal Sheet1 for columns B & C, but that doesn't seem to be the best way to do this, or is it?

Without seein the data it's difficult to say, but a PivotTable might work

Hello,

you could use a change event macro that copies every cell from Sheet1 as soon as it is entered. Right-click the sheet tab of Sheet1, click View Code and paste this code into the code window:

Please Login or Register  to view this content.

Or you could use a macro that copies columns B and C from Sheet1 to Sheet2 whenever Sheet2 is selected.

For the latter, right-click the sheet tab for Sheet2, select View Code and paste the following code into the code window.

Please Login or Register  to view this content.

cheers

The latter is the perfect solution, but there's one other criteria.. I need it to copy over those columns ONLY if a criteria is met on ColumnA (for each row) on Sheet1. For example, if ColumnA equals 1,2 or 3, then copy over the data of Columns B:C.

mcmuney,

please don't quote whole posts. It just clutters up the forum.

Also, it would be a lot easier if you set out your complete requirements from the start. Now, please mock up a workbook with some dummy data in Sheet1 and manually enter what you would like to see in Sheet2. Then attach that file to a new response to this thread.

cheers,

mcmuney, I'll write this very slowly to make sure you understand:

Don't quote whole posts. In fact, only quote if it is required to point out what part of what post you are replying to. There is no need to quote all (or most) of the previous post in the next reply.