VBA - If to copy cells across

[Ricardo Mass]

Hello everybody,

I am trying to use VBA to copy a selection of cells from one worksheet to another.

The criteria is column M being over $1,000,000, if met I would like to move some of the cells on that row to another worksheet, but as the second sheet is a summary it doesn't contain all of the same headers.

I am ok with the if statement, but unsure how to proceed with only copying some of the cells across, does anyone have any suggestions or places for me to look?

Is it a case of specifying each cell / range of cells to copy? I'm slightly unsure how this would look.


Many thanks

Rich

[apo]

Hi..

Use autofilter via VBA..

Attach your Workbook ( or at least a sample of it).. so we don't have to recreate it...

btw.. You should show where you have cross posted..

http://www.mrexcel.com/forum/excel-q...ls-across.html

[JOHN H. DAVIS]

Maybe this can help get you started.

Please Login or Register  to view this content.

[Ricardo Mass]

Thank you John, I will have a look at incorporating that