Compare and copy values across worksheets using macro

[rupes0610]

I need to create a macro that compares the values of the open worksheet to the newest worksheet (on the right of the current worksheet). It needs to go like this:

For each row, if columns A and B in CurrentWorksheet.pivottable (concatinated) are equal to the values in column A and B in PreviousWorksheet.pivottable (concatinated),

Copy values from PreviousWorksheet column D to ActiveWorksheet column D
Copy values from PreviousWorksheet column E to ActiveWorksheet column E
Copy values from PreviousWorksheet column F to ActiveWorksheet column F

Note that the pivot table varies in length. Is this possible, if so how can I do this? Your help is greatly apprecaited.

[arlu1201]

You want to copy values into a pivot table?

Why dont you explain with the help of a sample file?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.