My experience with Excel is very limited. I want to be able to use an Excel
spreadsheet to switch between information on different worksheets.

For example:
I want to look at Information A in columns A B and C which is on the
worksheet. I also want to look at information B in columns A B and C on the
same worksheet.
A B C A B C
Information A Information B
1
2
3
4
5
6
7
8
9
10
11
The numbers on the left are the row numbers.
How can I look at Information A and change to see Information B, C , D or F
which is on different worksheets. I would like to be able to switch rapidly
between the different information and compare on the one worksheet.



Any help gratefully accepted.

There can be only one column with the same designation A, B, C etc on a given
WorkSheet. You can however, assign text "names" to the top row of any column
and give it any label you wish. For instance column J might have the text
"A" in cell J1 as the header for the data below, but it's still column J as
far as Excel is concerned.

You can easily have two sets of data, using columns A, B, and C etc if you
put them on different WorkSheets, within the same WorkBook..........

hth
Vaya con Dios,
Chuck, CABGx3



"zephyr" wrote:

My experience with Excel is very limited. I want to be able to use an Excel
spreadsheet to switch between information on different worksheets.

For example:
I want to look at Information A in columns A B and C which is on the
worksheet. I also want to look at information B in columns A B and C on the
same worksheet.
A B C A B C
Information A Information B
1
2
3
4
5
6
7
8
9
10
11
The numbers on the left are the row numbers.
How can I look at Information A and change to see Information B, C , D or F
which is on different worksheets. I would like to be able to switch rapidly
between the different information and compare on the one worksheet.



Any help gratefully accepted.

Many Thanks for your assistance

"CLR" wrote:

There can be only one column with the same designation A, B, C etc on a given
WorkSheet. You can however, assign text "names" to the top row of any column
and give it any label you wish. For instance column J might have the text
"A" in cell J1 as the header for the data below, but it's still column J as
far as Excel is concerned.

You can easily have two sets of data, using columns A, B, and C etc if you
put them on different WorkSheets, within the same WorkBook..........

hth
Vaya con Dios,
Chuck, CABGx3



"zephyr" wrote:

My experience with Excel is very limited. I want to be able to use an Excel
spreadsheet to switch between information on different worksheets.

For example:
I want to look at Information A in columns A B and C which is on the
worksheet. I also want to look at information B in columns A B and C on the
same worksheet.
A B C A B C
Information A Information B
1
2
3
4
5
6
7
8
9
10
11
The numbers on the left are the row numbers.
How can I look at Information A and change to see Information B, C , D or F
which is on different worksheets. I would like to be able to switch rapidly
between the different information and compare on the one worksheet.



Any help gratefully accepted.