Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste using macro
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???? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste using macro
You are not very specific but maybe this? range("a3:h3").copy sheets("destination").range("a"&m5) Don Guillett SalesAid Software "kate" wrote in message ... 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???? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste using macro
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 "Don Guillett" wrote: You are not very specific but maybe this? range("a3:h3").copy sheets("destination").range("a"&m5) Don Guillett SalesAid Software "kate" wrote in message ... 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???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Paste using macro | Excel Discussion (Misc queries) | |||
Copy and Paste using macro | Excel Discussion (Misc queries) | |||
HELP with macro for copy and paste | Excel Discussion (Misc queries) | |||
Copy & Paste macro | Excel Worksheet Functions | |||
Copy Paste macro | Excel Discussion (Misc queries) |