I'm trying to modify a an excel file to improve its functionality, but unfortunately I don't have much experience with excel.
To explain my problem, let's say I have 2 worksheets: WS1 and WS2. WS1 contains all the data entered by the user. The first column contains integer numbers. I would like WS2 to contain a dynamic view of WS1. In particular WS2 should contain all the lines in WS1 whose first column contains "1". The content of WS2 should change automatically every time WS1 is updated.
Can I achieve this functionality with standard excel functionalities?
Thanks!
To explain my problem, let's say I have 2 worksheets: WS1 and WS2. WS1 contains all the data entered by the user. The first column contains integer numbers. I would like WS2 to contain a dynamic view of WS1. In particular WS2 should contain all the lines in WS1 whose first column contains "1". The content of WS2 should change automatically every time WS1 is updated.
Can I achieve this functionality with standard excel functionalities?
Thanks!