Excel Asset Filter & Edit Tool

My asset workbook holds roughly a thousand rows, each with an Asset No (e.g., D23414, D22946, D13460) and its current warehouse location. I already have this list ready in Excel, but updating locations one record at a time has become too slow.

What I need inside that same workbook is a quick way to:
• paste or type several comma-separated Asset Nos at once,
• trigger an advanced filter that instantly shows only those rows, and
• enter a single new location & date checked value and have it applied to every filtered record in one click.

A simple sheet-based interface, a VBA userform, or a Power Query solution is fine—whichever keeps the file self-contained and easy to maintain. I will be manually typing the new location & date checked, so no dropdown is required. Please add a basic check that warns me if an entered Asset No doesn’t exist.

Deliverables
• Updated Excel file with the multi-ID search and bulk-update functionality
• Well-commented VBA / Power Query steps so I can tweak later
• Short usage notes for refreshing or extending the list

Acceptance
I’ll consider the job done when I can paste “D23414,D22946,D13460”, press Search, type a new location & date checked once, hit Update, and see the location & date checked column change for all three rows simultaneously—no errors, no extra steps.