Macro to copy and paste values over a specific area based on cell value

[turnock17]

Hi

Im sorry if this has been posted before but i am struggling to find the answer

I would like to copy and paste special values over a range of cells in a column based on a cell value

E.g

A1 = 1 - Therefore copy and paste special values over A2:A10
B1 = 1 - therefore copy and paste special values over B2:B10
C1 = blank - do nothing to C2:C10

and so on

I would like this to work over multiple rows depending on the value in the corresponding column 1

Thanks
Matt

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post