About Us

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Referencing a cell to another worksheet	neostar77	Excel Discussion (Misc queries)	1	October 13th 08 09:23 AM
Can't Cancel r1c1 cell referencing in excel 2007	Yasaf Burshan	Excel Discussion (Misc queries)	3	June 24th 08 01:24 PM
Referencing a worksheet name to a cell...	QuietMan	Excel Worksheet Functions	10	May 20th 08 02:40 PM
Referencing another worksheet via a cell	[email protected]	Excel Worksheet Functions	2	October 31st 06 07:22 PM
how to include a cell reference that is contained in a cell withi.	dutchinny	Excel Worksheet Functions	5	October 24th 05 01:07 AM

Menu

About Us