F
flatbush67
I am trying to create a macro that will copy specific fields from 1
spreadsheet to another, based on certain criteria.
Example. Copy cells A5 - I5 from current spreadsheet to new spreadsheet
only if cell B5 > 0.
At the same time I need to copy cells L5 to T5 from current spreadsheet to
new spreadsheet only if cell Q5 > 0
Need to do this for all rows in the spreadsheet.
How do you accomplish this??
spreadsheet to another, based on certain criteria.
Example. Copy cells A5 - I5 from current spreadsheet to new spreadsheet
only if cell B5 > 0.
At the same time I need to copy cells L5 to T5 from current spreadsheet to
new spreadsheet only if cell Q5 > 0
Need to do this for all rows in the spreadsheet.
How do you accomplish this??