5th April 2012, 07:36 AM
|
Suspended
|
|
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
|
|
Excel Macro Help Please
882 938 0 0 0 982
918 0 0 0 0 982
246 339 421 542 697 983
258 319 399 490 790 983
471 546 635 743 872 983
These are Row examples of Columns B to G
I need a Macro that will copy and paste (Special,Values) C to G onto positions B to F
But only if F is greater than zero
I have perhaps 2000 Rows that need doing
I need a Macro that will save me manually doing this task.
|