Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Martin BN
 
Posts: n/a
Default worksheet linked to a cell

Is it possible to have a hidden worksheet linked to a cell and a formula in
the cell that links to the worksheet?
This would be perfect:
When cell k4 is activatet a worksheet opens and allows the user to wright
data in the worksheet. K4 in the original sheet shows =sum( : ) in the other
worksheet. It only has to be a very small working area, 2 collumns and up to
10 arrays...
Does this make any sense?

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
Making path of linked cell dynamic Negentropy Excel Discussion (Misc queries) 3 September 24th 05 09:02 PM
Data From One Worksheet To Be Used In A Cell In A Different Worksheet ratt Excel Worksheet Functions 5 August 16th 05 03:13 AM
xls worksheet formatting a single cell Archer------------> Excel Discussion (Misc queries) 1 April 30th 05 07:25 PM
Why can't I link a cell from worksheet to another when it has an . FV Excel Worksheet Functions 0 April 7th 05 06:33 PM
Linked cell location of hyperlink Jerry Excel Worksheet Functions 1 December 20th 04 05:01 PM


All times are GMT +1. The time now is 05:38 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"