Excel Macro: compare 2 sheets and create result sheet

Report
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
Hello,

I have two excel spreadsheets, spreadsheet 1 a sheet that list device names, spreadsheet 2 has device/machine name and custodian. Need to automate the process of reviewing the two spreadsheets and creating a final that shows the custodians matched with the device/machine name.



System Configuration: Windows / Edge 96.0.1054.29

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Wdouglas90,

Your query is unclear to me. Sheet 2 already has the custodians and the device/machine.

Maybe post some screenshots and/or post your workbook using a free filesharing site (always be careful with sensitive data) to clarify what you are trying to achieve. How does it look now and how you want it to look.

Best regards,
Trowa