Copyingfunctions from one worksheet to another

G

Guest

Is it possible to copy functions from one worksheet to another in the same
workbook and have them reference the cells (non-named cells) they formerly
calculated? For example, sum(A1:A5) on Worksheet 1 is copied and moved to
Worksheet 2, but still captures the sum of A1 to A5 on Worksheet 1, actively
capturing any changes to the cells on Worksheet 1.

Thanks for any advice!
 
B

Bernie Deitrick

Spyder,

Use cut and paste.

If you need to actually have a copy, press F2, select the formula in the formula bar, press Ctrl-C,
then Esc, then select another (blank) cell, press F2, and press Ctrl-V. Then Cut and paste that new
cell.

HTH,
Bernie
MS Excel MVP
 

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
Conditional Sum across WORKSHEET 6
Using countif on non-consecutive cells 5
Use Formula from another worksheet 3
How does one use a formula to bring over the formatting as well 1
Locating a Worksheet from another Workbook 12
Extracting Data from another worksheet based on user input 14
3d References 7

Top