Linking and updating spreadsheets

[Guest]

Hi.

I have just one workbook with multiple spreadsheets. I have 1 master
spreadhseet that I want to be updated by the other spreadsheets automatically
every time I add something new to the other spreadsheets. I'm not sure of
the best possible way to do this.

Ex. If I had five item numbers to one spreadsheet and 3 items numbers to
another spreadsheet, I would like the master list to be automatically updated
in no certain order with those 8 numbers and other information.

Any ideas? Thanks!

 

[Guest]

you can just type = and then click on the cell in the other sheet that you
want to "feed" the master sheet.The resulting formula will look something
like =sheet2!A1.The value in your master will always reflect the value in the
oher sheet

 

[Guest]

In the new worksheet and once the data is in there is there any way to leave
the data behind and severe any reference to =sheet2!A1 on the master sheet.

 

[Guest]

I realize that you can point to other cells in the master worksheet. Other
people who are not that familiar with Excel will be using it. They will go
into the other sheets. Once they insert their data, I would like the master
list to be updated with the new information that they enetered. If they
entered item nos. 55521, 32145, and 874569 in one sheet and 32654 and 95236
in a second sheet and 32189 in a third, I would like the master sheet to
update itself. If col. A row 456 and the next 5 are empty, those item
numbers and the other information entered into those rows will be placed in
those 6 empty rows in the master list. I'm thinking that the best way to
have this happen is with a macro firing either when the workbook is close or
opened. I can't think of how working with formulas, the automatic updating
and checking for duplicates can happen when the workbook is opened or closed.