Further Information
Hi thanks for your replies. I have uploaded the worksheet. I have no idea how to edit macros - I just hit record and stop!
So:
Objective
1. To filter those with an eligibility setting of "registered" into a separate sheet.
2. To filter those with an eligibility setting of "yes" into another separate sheet.
3. In both cases - each should update automatically when I update the data tab.
What I did
4. I created an advanced filter for "Eligibility" and "Yes" and set this up in the new worksheet.
5. I did the same for "Eligibility" and "Registered".
6. I set up a Macro recording me doing the advanced filter after I had tested it manually to ensure that it achieved the desired results. The macro recorded me doing the filters on BOTH sheets - I did not tick "unique records only".
The Problem
7. The filters worked fine manually but the macro created odd results after I had updated the "Data" shet - extra flat/apartment numbers appeared on their own (seemingly matching flat/apartment numbers from complete records i.e. if 23 Smith Street appeared, so did number 2 and number 3.
8. Also, when I changed 10 properties from "yes" to registered - although the 10 records should have disappeared from one sheet and appeared in another after the macro was run, the 10 records disappeared from "Unregistered" but did not appear in "registered" seemingly disappearing in translation.
Ideally, i'm just looking for the other two sheets to auto-update. The video demonstrates the issue best however - there is a fast forward option.
Thanks and Kind Regards,
indieben.
|