How to reference entire worksheet in new worksheet
Hi - I would like to reference an entire worksheet from a new worksheet.
Once I do that, I can sort and create different views without changing the original worksheet. My thinking is that whenever I change a cell in the referred to worksheet it will automaticall change in the new worksheet even though it is sorted. It this correct? Any help would be appreciated - Thanks. |
All times are GMT +1. The time now is 04:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com