Copy cells based on another cell's value

[Hokkaido]

Hi,

I'm new to VBA and still can't figure out how to solve this problem.

I have three tabs called DATA, NEW and OLD. The DATA! tab contains a data set out of which want to copy cell values based on the value column P. The NEW and OLD tabs are identical apart from cell B4, which contains the number that should be compared to the value in DATA!P.

If DATA!P5 = NEW!$B$4 I want cell values DATA!A5:N5 to be copied to NEW!A5:N5. If the value in the DATA!P5 equal the value in OLD!$B$4, then DATA!A5:N5 should be copied to the OLD! tab instead.

I apologize for the confussing description and thanks in advance for all potential help.

Best,
Alex

[estratosphere]

Can you attach your spreadsheet so that we can understand the problem better?

[Hokkaido]

I have attached a file. Thanks for the help.

[estratosphere]

Hi,

This code will work for copying to your OLD tab - put a button on your DATA tab and add:

Please Login or Register  to view this content.

Adjust the references for OLD to NEW and add to another button on your DATA tab for the NEW option

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Hokkaido]

Thanks a lot for your help guys, it's really appreciated.

[JOHN H. DAVIS]

You're welcome. Glad to help out.