View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Automatically update spreadsheet from another spreadsheet

Assume the 8-sheet book is called My Book.XLS
In cell A1 of sheet1 of the first new workbook, enter
=IF('[My Book.xls]Sheet1'!A1="","",'[My Book.xls]Sheet1'!A1)
There are two sets of double quotes in the formula: double-quote
double-quote comma double-quote double-quote
Copy this to the right as far as needed
Now copy row 1 down as far as needed.
Every time you open the new workbook it will be updated to show what is in
My Book

Note that if you add new data to My Book beyond the columns/row for formulas
in the other books, the new stuff will not appear. It is generally
considered poor practice to store the same data in two places (other than
for backup, of course) There may be a better way if we knew the purpose of
this exercise.
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Cindy" wrote in message
...
I have 8 sheets on one spreadsheet and I need to create individual
spreadsheets for each of the 8 sheets. The problem is I need the
information
I put into the spreadsheet with all 8 sheets attached to update on the
individual spreadsheets.

How can I do this? I feel like I'm just missing a step in the normal
formulas that I use.