View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Change data on number change

I have a table that has data in it. I would like to be able to change the
Column number and the Row Number to change what displays in A4. Is there an
easy way to do this? If I would type in Column 4 row 10 I would get Test7 in
A4 Thanks! Jeff

A B C D
1 Column 1
2 Row 8
3
4 Test 1
5
6
7
8 Test 2 Test5
9 Test3 Test6
10 Test4 Test7