Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Referencing an active cell's content from another sheet.

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Referencing an active cell's content from another sheet.

Shane,

Thanks for the quick response. I have a worksheet titled MainForm which
require cells A5, E5, H5, and E7 to automatically populate with data from a
2nd worksheet tiltled Pretrial. This sheet consist of 11 data rows. I'd like
to the content in these cells (First Name, Last Name, Date, etc.) to show on
MainForm automatically as the curser rests on the row of the Pretrial
worksheet. I know this is possible because I've seen it done. Your help is
greatly appreciated.

"Shane Devenshire" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to find cell content in sheets and make sheet active Nigel Excel Discussion (Misc queries) 4 June 26th 14 02:38 PM
Replacing Part of a Cell's Content mommy2kh Excel Worksheet Functions 5 July 13th 08 05:42 PM
Need to refer to a cell's address, not it's content... aduroche Excel Discussion (Misc queries) 3 October 18th 07 08:54 PM
Printing cell's content larger than cell width Neophyte New Users to Excel 1 October 14th 07 09:20 PM
How do you copy a cell's content verses it's formula? Tammy Excel Discussion (Misc queries) 1 March 2nd 05 07:30 PM


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"