Switching Information

Z

zephyr

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.
 
C

CLR

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
 
Z

zephyr

Many Thanks for your assistance

CLR said:
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
Click to expand...
 
Top