Constant Cell Problem

N

Nick Wakeham

I have a workbook in Excel 2007 with two worksheets in it Sheet1 and Sheet2.

On Sheet1 I have a reference to a row and cell on Sheet2 that I want to
remain constant.
That formula is: =Sheet1!$B$7 as the cell on Sheet1(with the formula) always
has to take its value from what is inserted in B7 on Sheet2. Each week a new
row on Row7 on Sheet2 has to be inserted. So I Copy Row, then Insert Copied
Row and start to replace some of the new figures in that row including B7.
When I go back to the Sheet1 - the formula above has changed to:
=Sheet1!$B$8

Basically I want the formula on Sheet1 ALWAYS to point to B7 on Sheet2 - how
do I do that?

Nick
 

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

Need Help with a VBA subroutine 0
Can you display entire rows that match a certain criteria... 1
Formula fill series? 1
Automatically copying data from sheet1 to sheet2 2
how can I copy/paste a formula that skips 27 rows? 0
macro for calculate and compare 0
Transpose between sheets 4
combo box2 reading a cell like vlookup 0

Top