Groping by column
 

Is there anyway to do the groping by column only ? Say, I want to gtoup
sheet1.column A and sheet2.column A. Thanks

Groping by column
 

For what purpose?
It is definitely possible to use a function against multiple sheets:
=SUM(Sheet1!A:A, Sheet2!A:A)

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"broogle" wrote in message
oups.com...
Is there anyway to do the groping by column only ? Say, I want to gtoup
sheet1.column A and sheet2.column A. Thanks

Groping by column
 

Sorry, I should be more specific. What I meant was If I change data in
sheet1.cell a1 it will be automatically change data in sheet2.a1. I can
do this by grouping the sheets, but what I want is just grouping the
column, is it possible? Thanks

Groping by column
 

No, you can't group just the column.

--
Regards,
Tom Ogilvy

"broogle" wrote in message
oups.com...
Sorry, I should be more specific. What I meant was If I change data in
sheet1.cell a1 it will be automatically change data in sheet2.a1. I can
do this by grouping the sheets, but what I want is just grouping the
column, is it possible? Thanks