same data from one cell copy to multiple sheets

G

Guest

I have 3 worksheet and I would like to have certain cell copy into a master
sheet.
So, when you enter a number into "sheet 1" in places it into "master" the
cells are not in the same exact spot. Is there a formula to make these cells
copy into mutiple sheets?
 
G

Guest

Copy Master cell onto different sheets:
Put this in the formula bar for the cell on each of the secondary sheets
that will match the master. =Sheet1!C13 with C13 being your master cell.

Use master sheet to add number value from different sheets:
The master cell should read =SUM(Sheet2!C13,Sheet3!C10) with your
secondary cells in place of C12 and C13.
Sometimes Excel requires you to put in a $ in the formula.
Hope this helps.
 

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

Pulling data from Sheets in A workbook 2
using the =page! feature to transpose a row to column 0
Formula Based on Multiple Sheets 5
Splitting data from one spreadsheet into multiple spreadsheets 2
Macro to Combine Data from Multiple Sheets with Cell References 4
Copy data to multiple sheets 2
Copy specific data form sheets into master sheet 6
Transferring data from multiple sheets in workbook to one sheet 5

Top