software

Here is a good one...I've been stuck on this one for a while now...

I currently have two worksheets open.
On Sheet1 in cells A1:A6 I have a bunch of serial numbers (one serial # per
cell).
On Sheet2 in cells A1:A4 I have the following formulas,
=INDIRECT(quot;SHEET1!A1) through A4.

SHEET 1
A1 = 100
A2 = 200
A3 = 300
A4 = 400
A5 = 500
A6 = 600

SHEET2
A1 =INDIRECT(quot;SHEET1!A1) the value is 100
A2 =INDIRECT(quot;SHEET1!A2) the value is 200
A3 =INDIRECT(quot;SHEET1!A3) the value is 300
A4 =INDIRECT(quot;SHEET1!A4) the value is 400

Now if I were to group cells A2:A3 on Sheet1, how do I get A2:A4 on Sheet2
to read correctly? Or group with sheet1?

SHEET1
A1 = 100
A4 = 400
A5 = 500
A6 = 600

SHEET2
A1 =NOCLUE(!?!?) the value is 100
A2 =NOCLUE(!?!?) the value is 400
A3 =NOCLUE(!?!?) the value is 500
A4 =NOCLUE(!?!?) the value is 600

Any help would be greatly appriciated. Thanks.

I can't duplicate your problem.

Of course, I also can't duplicate your posted formulas.
I assume you have a typo, and left out the second set of quotes:

=INDIRECT(quot;SHEET1!A1)
=INDIRECT(quot;SHEET1!A1quot;)

With the correct formula:
=INDIRECT(quot;SHEET1!A1quot;)
And grouping the rows using
lt;Datagt; lt;Groupamp;Outlinegt; lt;Groupgt;
My Sheet2 *doesn't* change at all!

The display is identical ... before and after grouping rows 2 and 3.

What exact formulas are you using?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Gabequot; gt; wrote in message
...
gt; Here is a good one...I've been stuck on this one for a while now...
gt;
gt; I currently have two worksheets open.
gt; On Sheet1 in cells A1:A6 I have a bunch of serial numbers (one serial #
per
gt; cell).
gt; On Sheet2 in cells A1:A4 I have the following formulas,
gt; =INDIRECT(quot;SHEET1!A1) through A4.
gt;
gt; SHEET 1
gt; A1 = 100
gt; A2 = 200
gt; A3 = 300
gt; A4 = 400
gt; A5 = 500
gt; A6 = 600
gt;
gt; SHEET2
gt; A1 =INDIRECT(quot;SHEET1!A1) the value is 100
gt; A2 =INDIRECT(quot;SHEET1!A2) the value is 200
gt; A3 =INDIRECT(quot;SHEET1!A3) the value is 300
gt; A4 =INDIRECT(quot;SHEET1!A4) the value is 400
gt;
gt; Now if I were to group cells A2:A3 on Sheet1, how do I get A2:A4 on Sheet2
gt; to read correctly? Or group with sheet1?
gt;
gt; SHEET1
gt; A1 = 100
gt; A4 = 400
gt; A5 = 500
gt; A6 = 600
gt;
gt; SHEET2
gt; A1 =NOCLUE(!?!?) the value is 100
gt; A2 =NOCLUE(!?!?) the value is 400
gt; A3 =NOCLUE(!?!?) the value is 500
gt; A4 =NOCLUE(!?!?) the value is 600
gt;
gt; Any help would be greatly appriciated. Thanks.Sorry about that little typo, you are correct the formula is
=INDIRECT(quot;SHEET1!A1quot;).

See when I group rows 2 and 3 on sheet1, I actually need sheet2 to reflect
the changes. For instance:

SHEET 1 (Notice how A2 amp; A3 are grouped)
A1 = 100
A4 = 400 (Now the value of 400 is next, this value should equal A2 on
sheet2)
A5 = 500 (This value should equal A3 on sheet2)
A6 = 600 (This value should equal A4 on sheet2)

SHEET 2
A1 = 100 (A1 on sheet1)
A2 = 400 (A4 on sheet1)
A3 = 500 (A5 on sheet1)
A4 = 600 (A6 on sheet1)

What formula(s) could I use instead of =INDIRECT(quot;SHEET1!A1quot;) to make that
happen? Or is there another way I could have excel do that?

Any help is greatly appriciated. Thanks.

quot;RagDyerquot; wrote:

gt; I can't duplicate your problem.
gt;
gt; Of course, I also can't duplicate your posted formulas.
gt; I assume you have a typo, and left out the second set of quotes:
gt;
gt; =INDIRECT(quot;SHEET1!A1)
gt; =INDIRECT(quot;SHEET1!A1quot;)
gt;
gt; With the correct formula:
gt; =INDIRECT(quot;SHEET1!A1quot;)
gt; And grouping the rows using
gt; lt;Datagt; lt;Groupamp;Outlinegt; lt;Groupgt;
gt; My Sheet2 *doesn't* change at all!
gt;
gt; The display is identical ... before and after grouping rows 2 and 3.
gt;
gt; What exact formulas are you using?
gt; --
gt; Regards,
gt;
gt; RD
gt;
gt; ---------------------------------------------------------------------------
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; ---------------------------------------------------------------------------
gt;
gt;
gt;
gt; quot;Gabequot; gt; wrote in message
gt; ...
gt; gt; Here is a good one...I've been stuck on this one for a while now...
gt; gt;
gt; gt; I currently have two worksheets open.
gt; gt; On Sheet1 in cells A1:A6 I have a bunch of serial numbers (one serial #
gt; per
gt; gt; cell).
gt; gt; On Sheet2 in cells A1:A4 I have the following formulas,
gt; gt; =INDIRECT(quot;SHEET1!A1) through A4.
gt; gt;
gt; gt; SHEET 1
gt; gt; A1 = 100
gt; gt; A2 = 200
gt; gt; A3 = 300
gt; gt; A4 = 400
gt; gt; A5 = 500
gt; gt; A6 = 600
gt; gt;
gt; gt; SHEET2
gt; gt; A1 =INDIRECT(quot;SHEET1!A1) the value is 100
gt; gt; A2 =INDIRECT(quot;SHEET1!A2) the value is 200
gt; gt; A3 =INDIRECT(quot;SHEET1!A3) the value is 300
gt; gt; A4 =INDIRECT(quot;SHEET1!A4) the value is 400
gt; gt;
gt; gt; Now if I were to group cells A2:A3 on Sheet1, how do I get A2:A4 on Sheet2
gt; gt; to read correctly? Or group with sheet1?
gt; gt;
gt; gt; SHEET1
gt; gt; A1 = 100
gt; gt; A4 = 400
gt; gt; A5 = 500
gt; gt; A6 = 600
gt; gt;
gt; gt; SHEET2
gt; gt; A1 =NOCLUE(!?!?) the value is 100
gt; gt; A2 =NOCLUE(!?!?) the value is 400
gt; gt; A3 =NOCLUE(!?!?) the value is 500
gt; gt; A4 =NOCLUE(!?!?) the value is 600
gt; gt;
gt; gt; Any help would be greatly appriciated. Thanks.
gt;
gt;

AFAIK, it can't be done!

Try posting to the programming group to see if it can be done with code.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Gabequot; gt; wrote in message
...
gt; Sorry about that little typo, you are correct the formula is
gt; =INDIRECT(quot;SHEET1!A1quot;).
gt;
gt; See when I group rows 2 and 3 on sheet1, I actually need sheet2 to reflect
gt; the changes. For instance:
gt;
gt; SHEET 1 (Notice how A2 amp; A3 are grouped)
gt; A1 = 100
gt; A4 = 400 (Now the value of 400 is next, this value should equal A2 on
gt; sheet2)
gt; A5 = 500 (This value should equal A3 on sheet2)
gt; A6 = 600 (This value should equal A4 on sheet2)
gt;
gt; SHEET 2
gt; A1 = 100 (A1 on sheet1)
gt; A2 = 400 (A4 on sheet1)
gt; A3 = 500 (A5 on sheet1)
gt; A4 = 600 (A6 on sheet1)
gt;
gt; What formula(s) could I use instead of =INDIRECT(quot;SHEET1!A1quot;) to make that
gt; happen? Or is there another way I could have excel do that?
gt;
gt; Any help is greatly appriciated. Thanks.
gt;
gt;
gt;
gt;
gt; quot;RagDyerquot; wrote:
gt;
gt; gt; I can't duplicate your problem.
gt; gt;
gt; gt; Of course, I also can't duplicate your posted formulas.
gt; gt; I assume you have a typo, and left out the second set of quotes:
gt; gt;
gt; gt; =INDIRECT(quot;SHEET1!A1)
gt; gt; =INDIRECT(quot;SHEET1!A1quot;)
gt; gt;
gt; gt; With the correct formula:
gt; gt; =INDIRECT(quot;SHEET1!A1quot;)
gt; gt; And grouping the rows using
gt; gt; lt;Datagt; lt;Groupamp;Outlinegt; lt;Groupgt;
gt; gt; My Sheet2 *doesn't* change at all!
gt; gt;
gt; gt; The display is identical ... before and after grouping rows 2 and 3.
gt; gt;
gt; gt; What exact formulas are you using?
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; RD
gt; gt;
gt;
gt; --------------------------------------------------------------------------
-
gt; gt; Please keep all correspondence within the NewsGroup, so all may benefit
!
gt;
gt; --------------------------------------------------------------------------
-
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Gabequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Here is a good one...I've been stuck on this one for a while now...
gt; gt; gt;
gt; gt; gt; I currently have two worksheets open.
gt; gt; gt; On Sheet1 in cells A1:A6 I have a bunch of serial numbers (one serial
#
gt; gt; per
gt; gt; gt; cell).
gt; gt; gt; On Sheet2 in cells A1:A4 I have the following formulas,
gt; gt; gt; =INDIRECT(quot;SHEET1!A1) through A4.
gt; gt; gt;
gt; gt; gt; SHEET 1
gt; gt; gt; A1 = 100
gt; gt; gt; A2 = 200
gt; gt; gt; A3 = 300
gt; gt; gt; A4 = 400
gt; gt; gt; A5 = 500
gt; gt; gt; A6 = 600
gt; gt; gt;
gt; gt; gt; SHEET2
gt; gt; gt; A1 =INDIRECT(quot;SHEET1!A1) the value is 100
gt; gt; gt; A2 =INDIRECT(quot;SHEET1!A2) the value is 200
gt; gt; gt; A3 =INDIRECT(quot;SHEET1!A3) the value is 300
gt; gt; gt; A4 =INDIRECT(quot;SHEET1!A4) the value is 400
gt; gt; gt;
gt; gt; gt; Now if I were to group cells A2:A3 on Sheet1, how do I get A2:A4 on
Sheet2
gt; gt; gt; to read correctly? Or group with sheet1?
gt; gt; gt;
gt; gt; gt; SHEET1
gt; gt; gt; A1 = 100
gt; gt; gt; A4 = 400
gt; gt; gt; A5 = 500
gt; gt; gt; A6 = 600
gt; gt; gt;
gt; gt; gt; SHEET2
gt; gt; gt; A1 =NOCLUE(!?!?) the value is 100
gt; gt; gt; A2 =NOCLUE(!?!?) the value is 400
gt; gt; gt; A3 =NOCLUE(!?!?) the value is 500
gt; gt; gt; A4 =NOCLUE(!?!?) the value is 600
gt; gt; gt;
gt; gt; gt; Any help would be greatly appriciated. Thanks.
gt; gt;
gt; gt;