Excel Macro: compare 2 sheets and create result sheet

wdouglas90 - Updated on Jan 11, 2022 at 11:50 AM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen October 4, 2022 - Jan 11, 2022 at 11:23 AM
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

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen October 4, 2022 523
Jan 11, 2022 at 11:23 AM
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
0