Hi,
I have data in two sheets namely Master data and final data. In final data sheet, you can get the data as per datewise by changing the date you want in Cell E1.
You can get the data by unselecting the zeros in filter E4. But whenever i change the date in cell E1, i need to get the data in the same sheet excluding zero automatically instaed of unselecting the zero every time. Is there any macro that can fulfill this? please help.
Attached the data for ur ref.
Thanks.
Bookmarks