Excel 2002 - copying formulas across worksheets

G

Guest

I have several worksheets linked together in the same file. I am trying to
copy a worksheet (sheet2) into a new worksheet (sheet3) and not all of the
formulas changed. All formulas with a worksheet reference (ie. Sheet1!) will
not change. One of the formulas I am working with is as follows:
=+Sheet1!b3+1

This formula is located on sheet2. This purpose of this formula is to take
a previous total (from sheet1) and increment it by 1 on the new work sheet
(sheet2). When I create a new sheet3 and copy sheet2, the formula remains
linked to sheet1. I want it to take the previous total from sheet2. How do
I fix it so that when I copy this formula, it will change automaticly?

I appreciate anyones help on this.
 
G

Guest

If I'm understanding you correctly, I think the solution is easy. In the new
sheet(3), change that =+Sheet1!b3+1 to +=Sheet2!b3+1
I 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

EXCEL - IF(IFERROR(VLOOKUP question 0
excel 2002 - copying formulas to another worksheet 2
getting info from one worksheet to another 3
formula problem in grouped worksheets 1
Formula to reference another worksheet 4
Copying multiple cells out of multiple worksheets at same time. 1
Problem with formula in grouped sheets 2
alter code to apply to range (links cells w/ row insertions) 1

Top