How do I force Excel to use fixed cells on a different worksheet?

  • Thread starter Craig Spencer UK
  • Start date
C

Craig Spencer UK

I am trying to set up a spreadsheet that has a summary sheet collating
information from other worksheets in the same workbook. However, whenever I
insert a column in the other worksheets the formula changes to track the
original value, rather than staying with the same cell. I need it to always
refer to the same cell in order to get an average of the 3 most recent
entries on that worksheet. How d I do this?
 

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

External cell reference between two excel worksheets both in One Drive 0
Protection of cells in a worksheet 2
Referrence a total in a cell on another worksheet 4
Code to format cells on several worksheets 2
Duplicating a cell from one worksheet to another worksheet 1
same formula and cells for different worksheets 1
Auto deletion of cell entry in given circumstance 0
Formulae Ref Different Worksheets 1

Top