Duplicate worksheet
Data is entered into the main DATA sheet.
But i want most of my work to happen on the analysis sheet. Here most of the colums arent relevant, so i would hide them and use the relevant columns for analysis. Is there anyway to duplicate the data worksheet. with live updating, or maybe with an event everytime i activate my analysis sheet. And copied with a reference so that if there is any change in the data, it changes in the analysis sheet too. |
All times are GMT +1. The time now is 06:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com