Groping by column

  • Thread starter Thread starter broogle
  • Start date Start date
B

broogle

Is there anyway to do the groping by column only ? Say, I want to gtoup
sheet1.column A and sheet2.column A. Thanks
 
For what purpose?
It is definitely possible to use a function against multiple sheets:
=SUM(Sheet1!A:A, Sheet2!A:A)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheet to sheet code Type Mismatch 6
My Never ending ARRAY code problems 18
fill in data that is not empty 1
Merging 2 sheets. 1
loop to copy paste 5
Hiding a column if a cell has an X 1
Need some help constructing a Do While statement 2
Match columns to rows then loop. 2

Back
Top