spreadsheet corrections or additions

C

cajun1

have a main spreadsheet to pull data from.that way an update to cells there
would flow changes to the other spreadsheets.Can that be done other than to
manually
copy and paste?
 
K

kassie

Not exactly clear what you are trying to achieve. For starters, you could
link the files with formulae. Say you have BookOne.xls and BookTwo.xls, and
you want to link a cell in BookTwo.xls to a cell in BookOne.xls. Lets say
BookOne.xls is the main sheet.

In cell A6 in BookTwo.xls, you want the same result as in BookOne.xls, cell
B15. In BookTwo.xls enter =BookOne!.B15 Can you work with that?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Copy addition formula of non-consecutive horizontal cells 2
Linking data in MS Word into Excel 5
Re-title multiple MS Project .mpp files at once 0
Embed the same Excel multiple times 0
Excel does not accept text format! 0
Need Help with a VBA subroutine 0
Grouping Names in Mail Merge 0

Top