ExcelBanter - View Single Post - Excel 2007 - referencing a cell value from another worksheet withi

Alojz

hi,

o.k. if you like, send it to , will have a look tomorrow
around this time. May take some time till I answer, busy at work, looking
here just on evenings, now is close to midnight at place where I live.

"crisg" wrote:

Hello Alojz-
Yes, I did type the = sign in Sheet 3, D3. I also have it set to show the
results instead of the formula.
Is there a way for me to attach the worksheet to this post so that you can
see it for yourself?

Thanks,
--
crisg

"Alojz" wrote:

In sheet3, cell D3, do you type eqals sign at the beginning?
In options: don't u have checked: show formulas instead of results?

"crisg" wrote:

Hi -
This appears to be a very simple process - but not matter what I do I cannot
get it work.

I have Sheet 1 through Sheet 4 of a workbook
Sheet 1 contains all values
Sheet 2-3 contain subsets of the values from Sheet 1
I would like for Sheet 2 and Sheet 3 to automatically update when the values
are updated in Sheet 1
All cells contain text only, not formulas
I have tried every combination possible and I cannot get the values in
Sheet2 - Sheet 3 to update automatically
Here is an example - In Sheet 3, Cell D3 I want to reference the value from
Sheet 1 Cell D46
I go to Sheet 3, Cell D3 and enter
Sheet1!D46 - does not work
Sheet1!D$46$ - does not work
= in front of the previous 2 references does not work
CELL(Sheet1!D46)
CELL(Sheet!D$46$)
I've used INDIRECT and countless other samples and no matter what I try -
all i can see in the Cell is the reference that I just typed in.
I know it's very easy and I'm missing some simple step - but I can't see it.
Thank you in advance for your assistance.

Regards,

--
crisg