how to automatic copy

[no dice]

Hello code warriors. Any idea how I can do the following?

If there is data in M3, then copy the formulas from N2, O2, & P2 into N3, O3, & P3.

The process to continue down for ~2000 rows.

[stevekirk]

hi
try

in cell n3 put

=IF(M3<>" ",N2,"")

then copy this to O AND P cells
then copy down

hope this helps
steve

[Trebor76]

no dice,

If you want a macro, you could use the following:

Please Login or Register  to view this content.

HTH

Robert

[no dice]

Thanks! Appreciate the help.

[no dice]

Tried both solutions and neither quites fit the bill.

First, both produce zeros in N, O, & P when M is blank. Desired output to to do nothing until M is populated.

Thoughts?

[Trebor76]

Hi there,

Could it be the result of a past incidence of the macro being run?

If not, attach a sample spreadsheet (with some notes) and I'll have a look.

HTH

Robert