Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste formula using vb code
Can anybody tell me what vb code do I use for the following:
I would like it to copy and paste formula starting from columns "H11:L11" everytime data is inserted in the cells, the code would paste the formula down one row automatically. Thank you -- ASU |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste formula using vb code
Allow me to re-state it, to make sure I understand it properly:
When the user enters data in the range H11:L11, a formula is copied and pasted down one row automatically. If that is correct, where is the formula that is copied? If my restatement is wrong, please correct it. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste formula using vb code
Yes , thats correct......eg. the formula in say "H11" is copied and pasted to
"H12". Like wise with cells "I11" through to "L11". The formula in "H11" is as follows: =SUMIF($A$3:A3,A3,$H$11:H11)-SUMIF($A$3:A3,A3,$E11:E11) I'v tried dragging down, each column, to row 5000. But I found that it slowed the file when opening and closing. Other way would to use vb codes to do the maths! -- ASU "Dave O" wrote: Allow me to re-state it, to make sure I understand it properly: When the user enters data in the range H11:L11, a formula is copied and pasted down one row automatically. If that is correct, where is the formula that is copied? If my restatement is wrong, please correct it. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste formula using vb code
Try this code:
netrang = "H11:L11" startrng = "H11" Range(startrng) = "=SUMIF($A$3:A3,A3,$H$11:H11)-SUMIF($A$3:A3,A3,$E11:E11)" Range(startrng).AutoFill Destination:=Range(netrang), Type:=xlFillDefault Larry "ASU" wrote: Yes , thats correct......eg. the formula in say "H11" is copied and pasted to "H12". Like wise with cells "I11" through to "L11". The formula in "H11" is as follows: =SUMIF($A$3:A3,A3,$H$11:H11)-SUMIF($A$3:A3,A3,$E11:E11) I'v tried dragging down, each column, to row 5000. But I found that it slowed the file when opening and closing. Other way would to use vb codes to do the maths! -- ASU "Dave O" wrote: Allow me to re-state it, to make sure I understand it properly: When the user enters data in the range H11:L11, a formula is copied and pasted down one row automatically. If that is correct, where is the formula that is copied? If my restatement is wrong, please correct it. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste formula using vb code
Im afraid it doesn't work. It doesn't recognizes netrang.
Is there another way? -- ASU "lar.ridge" wrote: Try this code: netrang = "H11:L11" startrng = "H11" Range(startrng) = "=SUMIF($A$3:A3,A3,$H$11:H11)-SUMIF($A$3:A3,A3,$E11:E11)" Range(startrng).AutoFill Destination:=Range(netrang), Type:=xlFillDefault Larry "ASU" wrote: Yes , thats correct......eg. the formula in say "H11" is copied and pasted to "H12". Like wise with cells "I11" through to "L11". The formula in "H11" is as follows: =SUMIF($A$3:A3,A3,$H$11:H11)-SUMIF($A$3:A3,A3,$E11:E11) I'v tried dragging down, each column, to row 5000. But I found that it slowed the file when opening and closing. Other way would to use vb codes to do the maths! -- ASU "Dave O" wrote: Allow me to re-state it, to make sure I understand it properly: When the user enters data in the range H11:L11, a formula is copied and pasted down one row automatically. If that is correct, where is the formula that is copied? If my restatement is wrong, please correct it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy & paste formula between spreadsheets - not working | Excel Worksheet Functions | |||
copy paste formula to skip rows | Excel Worksheet Functions | |||
convert formula to its value w/out copy and paste | Excel Discussion (Misc queries) | |||
How can I copy and paste the text of a formula? | Excel Worksheet Functions | |||
Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) |