Referencing cells from other sheets

Hey George,

Let's back up a minute... Why did you move all your stuff to a second page in the first place. Maybe there is a better way to accomplish your goal. Can you supply a sample workbook to show what you have/had and what you want to accomplish?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Maybe you can add the expected result on the summary sheet manualy.

As far as I can see both sheets are identical.

show it in your file for helping the forummembers to solve your problem.

Probably that could be done. See the reply in #2 of MarvinP. Why all data duplicating in sheet 2.

Make the analyses in sheet 1, e.g. with a pivot table.

Hey George,

I think I see what the problem is... On your Entry sheet the formulas refer to $C$9 that is absolute and doesn't move. On the second sheet you copied sheet 1 a row down from sheet1 making $C$9 on the second sheet a blank (or equal to zero).

Because your copy was one row down, the two sheets are NOT exactly the same and throws your formulas off.

Does this help? Do you see the problem now?

It is just a guess, but according your reply I guess you don't understand it fully.

F4=E4*($C9/100) and drag down.

In that case you don't have to change all data manualy.


The $ holds the criteria thats just after that $-sign.

$C9 holds column C when you copy it below and changes the row into C10 and after that in C11.

$C$9 holds Column C and row 9 when you copy it across.

C$9 changes column C into Column D and after that in column E if you copy that to the right. It leaves the rownummer the same (9).

Hope I explained well enough.

Thanks for marking the question solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.