ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   worksheet linked to a cell (https://www.excelbanter.com/excel-worksheet-functions/61180-worksheet-linked-cell.html)

Martin BN

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?



All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com