Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste formula +1
Hi,
I need to copy and paste a formula from cell D18 [formula is =(9-SUM(SEP07))], SEP07 being the range D19:D29, into cell E18. this I have managed to do but I then need the formula to incorporate a new range, i.e. =(9-SUM(OCT07)), OCT07 being range E19:E29, when the formula is pasted into the new cell (E18). The people in this discussion group have been very helpful in the past and hopefully some one can suggest a macro to perform this task. thanks in advance sevi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy & paste formula | Excel Discussion (Misc queries) | |||
FOrmula Copy and Paste | Excel Worksheet Functions | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
formula for copy and paste | New Users to Excel |