View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Referencing an active cell's content from another sheet.

Hi,

Please be a little more specific. What do you want to see where and when?
If you are scrolling with the scrollbar, then if you want to see in cell A3
of sheet2 the contents of cell R199 of sheet1 you will need a formula in A3
which refers to R199.

As you scroll with a scrollbar Excel does not take any active action so all
you will see is what is already in the cells via formulas.

???
Shane Devenshire

"emon" wrote:

I need help. I'd like to be able to manually scroll down column A of
worksheet 2 and populate cells on Sheet 1 accordingly. How can this be
accomplished? Please help.