Road Hawg
New Member
- Joined
- Oct 5, 2005
- Messages
- 7
My End Game is to create a dashboard. In doing this I have a workbook that has a worksheet (Computed) and a worksheet (Data). The Computed worksheet contains a table where every cell is either linked to a cell in a table in the Data worksheet or it is a computed field (mostly calculating time). I want to protect the Computed worksheet so end users can't change anything.
The Data worksheet gets its data from a manual copy and paste from a 3rd party medical software we can't link to. I'd like to find a way to have the Table on the Computed worksheet auto expand as more rows are pasted to the Table on the Data worksheet.
The Data worksheet gets its data from a manual copy and paste from a 3rd party medical software we can't link to. I'd like to find a way to have the Table on the Computed worksheet auto expand as more rows are pasted to the Table on the Data worksheet.
