Excel Macro: compare 2 sheets and create result sheet

Closed
wdouglas90 - Updated on Jan 11, 2022 at 11:50 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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