Switching Information
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.
|