I'm using Excel 2003 (11.8117.8107) SP2.
There are two spreadsheets in the attached workbook.
There are no macros in the attached workbook.
The user names shown in column A of the “Vendor Data” spreadsheet are the same user names shown in the name column (column A) of the “User Data” spreadsheet. There are no duplicate rows in “User Data” but there are duplicate rows in the “Vendor Data” spreadsheet.
What I need is a process to accomplish the following:
For each name in column A in the “Vendor Data” spreadsheet:
1. Find that name in column A of the “User Data” spreadsheet and change that entire row to bold to indicate that this name was found and processed.
2. Copy the cell contents of columns B&C in the “User Data” spreadsheet to columns D&E in the “Vendor Data” spreadsheet.
Any help you can provide is appreciated.
Thanks,
Jack Gombola
Bookmarks