PDA

View Full Version : Macro to Paste Cells when Column A=0



jonathanwhym
03-31-2012, 09:46 PM
Hi All,

I am fairly new to VBA and am hoping asome one can help me out here.

I would like to copy and paste a range of cells, H100-R100 and paste them in the same columns but only in rows where there is a 0 in column A.

I have around 100 rows of data which are coded with 0 or 1 depening on certain other criteeria.

Can any one help me out with a code for this, I dont know where to start and havnt been able to find anything similar to adapt online.

Cheers,
Jono

dazwm
03-31-2012, 11:31 PM
Please attach a sample workbook with a before and after example.