copy and paste using macro

K

kate

What I would like to do is copy and paste from a specific range using row
count.
I can copy and drop down but I only ever want it to copy and paste required
cells.


In m5 it will show how many rows I am using from another sheet and I wish to
copy my formulas from a3-h3 down to that specific row????
 
K

kate

I apologise in M5 it tells me at this precise month how many rows from sheet
1 should have formulas copy and pasted e.g

Cell m5 shows 697

So i would like my range to be copy (a4:h4)
to a5:(and this is where i get stuck) down to h697 by looking up cell m5??
Is this any clearer???
Thanks
 
D

Don Guillett

Maybe this. All ONE line
sheets("source").range("a4:h4").copy sheets("destination").range("a5:h" &
m5)
 
Top