linking source document cells to corresponding worksheets

B

btcdeb

Is there a way to link numerous cells in a source
spreadsheet to corresponding invidiual worksheets and have
the figures drop in automatically and calculate? Any help
will be greatly appreciated.
 
K

Keith

Not sure what your question is.

If you want to link cell A1 in Sheet1 to cell D4 in
Sheet2, you click on A1, type in "=" (without the quotes),
go to Sheet2, click in cell D4, and hit the enter key. You
can do that with as many cells and sheets as you wish.

Was that your question?
 

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

Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Mail Merge Directory Conditional Page Break 0
Syncing between source worksheet and dependent worksheets 0
How to make repeating drop-down lists? 2
How to link seperated documnet into a single document 0
Populate a table based on check box status 2
Linking data in MS Word into Excel 5
MS Project Center-Autolink column fields 0

Top