How do I copy formula cells from one worksheet to another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook open with 4 worksheets. 3 of the worksheets contain data
and totals. I want to be able to copy the totals only to the 4th worksheet,
and automatically update as I update the data on the other 3 worksheets. Any
help is appreciated.
 
I am no expert, but if you name the cells you can put them on any sheet you
want. You may name them and make a cell on another sheet equal to them, or
name them and move them anywhere so they only appear in one place.
gary
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy cells in Excel 1
Copy formula from one worksheet to another to get value in 2nd wks 1
Excel Move or Copy Stopped Working? 0
COPY SUM FORMULAS TO SEVERAL OTHER WORKSHEETS 3
Copy data from one worksheet to another 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
how do I use a cell from one worksheet in the equation of another 3

Back
Top