Main worksheet to automatically update figures on other worksheets

  • Thread starter Thread starter Deb A
  • Start date Start date
D

Deb A

I have a main worksheet with 10 columns with $ values. Each of those 10
columns need to have their own individual worksheet. How do I get the
individual worksheet columns to automatically update the main worksheet when
changes are made?
 
In the Main sheet you would have a formula like:

=Sheet1!A1

to get a value from A1 of sheet1, and you can copy this down (obviously
changing the sheet name and cell reference to suit your situation). In
adjacent columns you can have similar formulae, but referring to different
sheet names.

Hope this helps.

Pete
 

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

Date of worksheet comes out numbers on other linked worksheet 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Help? with extracting unsorted data from a worksheet, no blank lin 4
linking two worksheets in the same workbook 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Using a Master Worksheet 1
Automatically populate cells based on info in another worksheet 2
Worksheet Names using Macros 5

Back
Top