Loop macro greater than zero & paste.

[Randyt]

I am looking for a macro which will look in column "c" starting at c9 and if c9 > 0, then copy $d$3:$m$8 to cell d9. If it is true, copy & paste, if false, go six cells down and check if this cell is greater than zero and so on.
Any help is greatly appreciated!

[Roger Govier]

Hi Randy

You don't say how far down column C the macro has to run.
Is it always the values from D3:M8 that are to be copied, or a different range as you go down the sheet?
Can we assume that the second occurrence will be posted to D15, then D21 etc., or are the values to be posted to D10, D11 and so on?

[Randyt]

It will run down "c" maybe 4000 cells, this could fluctuate.
Yes, it is always values D3:M8 that are copied and yes they will be posted to D15; D21; etc.

[Randyt]

"bump, no response"

[Roger Govier]

Hi Randy

Try

Please Login or Register  to view this content.

[Randyt]

Roger, works like a champ!!! Does exactly what I needed it to do. Thank You So Much!!! You guys are the best, don't know what I'd do with out you.