Announcements
5
I spent the whole afternoon on this and didn’t get very far. I have two Excel sheets containing data. Both have a SERIAL NUMBER column. All I want to do is check whether a serial number appears in both sheets, and then output the whole line from my Master sheet to third Excel file.
I’ve managed to turn the column from one sheet into an array but what next? How do I search the Master sheet with it and output matching rows?
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (