Re: [users] multiple spreadsheets

2007-11-13 Thread Brian Barker
At 19:38 12/11/2007 -0800, Walter Hildebrandt wrote: How can I enter data into one spreadsheet and have the same data automatically appear on other spreadsheets. Here are two ways: o You can reference material from one spreadsheet directly in another: just swap between windows when you are e

Re: [users] multiple spreadsheets

2007-11-12 Thread Drew Jensen
noranross wrote: Wouldn't it be easier to just put a reference in the other sheets to the cell on the data entry sheet and then the data will automatically be updated. Drew Jensen wrote: Walter Hildebrandt wrote: How can I enter data into one spreadsheet and have the same data automatically

Re: [users] multiple spreadsheets

2007-11-12 Thread noranross
Wouldn't it be easier to just put a reference in the other sheets to the cell on the data entry sheet and then the data will automatically be updated. Drew Jensen wrote: Walter Hildebrandt wrote: How can I enter data into one spreadsheet and have the same data automatically appear on other sp

Re: [users] multiple spreadsheets

2007-11-12 Thread Drew Jensen
Walter Hildebrandt wrote: How can I enter data into one spreadsheet and have the same data automatically appear on other spreadsheets. - Get easy, one-click access to your favorites. Make Yahoo! your homepage. 1) Write a macro to copy the data from

[users] multiple spreadsheets

2007-11-12 Thread Walter Hildebrandt
How can I enter data into one spreadsheet and have the same data automatically appear on other spreadsheets. - Get easy, one-click access to your favorites. Make Yahoo! your homepage.