dynamic link from one sheet to next

W

Windjamer

I'm not a spreadsheet enthusiast, but do use Excel for bookkeeping. I want
to have the entry amount for a new month (sheet in a workbook) be the total
from the previous month. However, if I add a line item or correct a previous
entry, I don't want to have to correct the entry or link.

Presently I'm using "=+November03!G32" or "=+subtotal_nov" but have little
confidence in either. What should I be doing?

Thanks for any help.

Glen

(e-mail address removed)
"Living on Earth is expensive, but it does include a free trip around the
sun every year." Anonymous
 
D

Don Guillett

If you total for column G is in g32 and you insert a row ABOVE it the
formula will adjust and you don't need the Lotus + so

=November03!G32
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entertainment Budget Sheet 3
Copy of value from one sheet to another with matching column values 1
Pulling data from the previous sheet 9
Data selection from one worksheet into a second worksheet. 1
Copy row data from one sheet to one or more sheets depending on numberof tick boxes selected (in the 3
<Select sheet> window 2
Import data from individual employee monthly location sheets to onedepartment monthly location sheet 14
Create a Dynamic Link 1

Top