Rookie excel user. Cannot find directions for what I want to do.
I have an excel WS1 set up as DB; I want to keep this sheet for data revision.
WS2,3, 4, & 5 will be data that is filtered and sorted, using WS1 as source so I want to auto copy the WS1 data.
Can I just auto copy WS1 (how do I do that?) then filter and sort in each WS?
Thanks for helping a beginner.