Help making a process more automated!

Hi I have a worksheet of raw data and I want to apply a filter and have the filtered data copied to a new worksheet. I want it such that whenever the raw data in the first sheet is replaced, the second worksheet is automatically updated with the filtered data. Please help, deadline coming up soon!

Thanks

.
Paste this in the first Sheet Level module :

Please Login or Register  to view this content.

Anything you enter/change on the first sheet, will be reflected on the second sheet.

Hi,

Thanks for your response. I'm not great with excel. I would really, really appreciate it if you could help me with a step by step on what to do?

Ok thank you i got it. How do I change it so that on the second worksheet it automatically opens a filtered table when i change the entire raw data table? i.e without me having to filter the raw data manually?