I'm building a budget workbook system as follows:
The first workbook consist of worksheets for each cost center that link to a
summary page.
The second workbook takes the amounts in the summary page from the two
different workbooks (one being the 1st workbook of cost center and another
with payroll information) to a master object code workbook by department
heads and by two different catagories.
The third workbook takes the information from the second workbook into a
master worksheet that will show by two divisions and 5 or 6 catagories.
I'm not sure how to do the links or is there an easier way to build this.
I'm a medium level user of Excel. I would like to produce an end product
that I only have to change the information one time and it changes it on up
the line in a efficient manner.
I'm using Excel 2007 and I was trying to understand the consolidating
function but it is not sinking in.

--
Sheila Lindergren
Financial Management Analyst
City of Bradenton

I agree it is esssential that data be enterd only once to prevents erros.

If I am in Sheet 1 of Book1 I type type =; then clcik on a cell in another
sheet (which can be in same or different workbook), then I get a formula like
='[Other Book].Jan Sales'!A1

You can also do lookups (VLOOKUP) from book to book.
Your question to too broad to give a good answer to. Truely, I suffest you
read a book like Excle for Dummies and get to know Excel a bit better before
you start. Then we can give beter advice.
best wishes
--
www.stfx.ca/people/bliengme


"slindergren" wrote:

I'm building a budget workbook system as follows:
The first workbook consist of worksheets for each cost center that link to a
summary page.
The second workbook takes the amounts in the summary page from the two
different workbooks (one being the 1st workbook of cost center and another
with payroll information) to a master object code workbook by department
heads and by two different catagories.
The third workbook takes the information from the second workbook into a
master worksheet that will show by two divisions and 5 or 6 catagories.
I'm not sure how to do the links or is there an easier way to build this.
I'm a medium level user of Excel. I would like to produce an end product
that I only have to change the information one time and it changes it on up
the line in a efficient manner.
I'm using Excel 2007 and I was trying to understand the consolidating
function but it is not sinking in.

--
Sheila Lindergren
Financial Management Analyst
City of Bradenton