| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Macro Total Sum
Sheet 1 Column a Row 1-5
Copy of cells to sheet two a1 put a total two rows below list a7 this time. The next time sheet one may have row 1-10. Now macro should put answer on a12 and total rowa 1-10. ANy help. New to writing macros |
|
#2
|
|||
|
|||
|
Hi Joey. Take a look at this site. It may help.
http://www.xldynamic.com/source/xld.LastValue.html -- Sincerely, Michael Colvin "Joey" wrote: Sheet 1 Column a Row 1-5 Copy of cells to sheet two a1 put a total two rows below list a7 this time. The next time sheet one may have row 1-10. Now macro should put answer on a12 and total rowa 1-10. ANy help. New to writing macros |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| Date macro | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| macro - adding rows to a column that is summed | Excel Discussion (Misc queries) | |||
Linear Mode
