Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Annual From Monthly Cashflow
Hi,
I have one worksheet A with Monthly Cashflows from say A1 to IZ1. Now In another worksheet B I want to create the annual cashflow so I want in the worksheet B. The formula referencing to worksheet A to be SUM(A1:A12), SUM(A13:A24), etc.... Is there some way to get this done using a "drag n drop" or "cut n paste" technique? I use a macro nowadays ... but wonder if there is an easier way? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a newly created worksheet | Excel Worksheet Functions | |||
IRR calc Monthly vs Annual | Excel Worksheet Functions | |||
How do I forecast monthly and annual totals from previous year's . | Excel Worksheet Functions | |||
How do you calculate rate of return on monthly cash flows | Excel Worksheet Functions | |||
Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions |