I have a spreadsheet that will eventually consist of over 30 sheets. Each
sheet will have information that I want to be entered into a formula on a
totals sheet. Is there a way to have formulas automatically update as I add
a new sheet?
I have a spreadsheet that will eventually consist of over 30 sheets. Each
sheet will have information that I want to be entered into a formula on a
totals sheet. Is there a way to have formulas automatically update as I add
a new sheet?
Try this method:
http://www.officearticles.com/excel/...worksheets.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com
"Reepicheep" <[email protected]> wrote in message
news:[email protected]...
>I have a spreadsheet that will eventually consist of over 30 sheets. Each
> sheet will have information that I want to be entered into a formula on a
> totals sheet. Is there a way to have formulas automatically update as I
> add
> a new sheet?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks