View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
zephyr
 
Posts: n/a
Default 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.