Cell value trigger copy paste macro

[byrdsongdl]

In Sheet1 I want the button macro to look at cell C6 and if the cell has a value of 1847WM then I want it to copy cells A25:A35 and paste it in Sheet 2 on Column C



Thanks for the help.

[Richard Buttrey]

Hi,

Untested and assuming the button is on the same sheet as the C6 value and A25:A35 values that you're interested in and hence the active sheet, something like:

Please Login or Register  to view this content.

You didn't say whereabouts in column C you wanted the paste to take place so I have assumed C25. Change as necessary.

HTH