had1015
10-26-2016, 03:29 AM
Hi,
I would like to create a macro to compare one worksheet to multiple sheets in the same workbook. Worksheet 'Master" column F contains ID. Other worksheets columns C contains ID as well. I'd like to find where ID in column F on the "Master" sheet matches all other sheets columns C except "Index" sheet and copy the Manager from worksheet "Master" column H to other sheets column P. So all sheets except Master and Index would be updated in column P. Any assistance you provide would be greatly appreciated.
I would like to create a macro to compare one worksheet to multiple sheets in the same workbook. Worksheet 'Master" column F contains ID. Other worksheets columns C contains ID as well. I'd like to find where ID in column F on the "Master" sheet matches all other sheets columns C except "Index" sheet and copy the Manager from worksheet "Master" column H to other sheets column P. So all sheets except Master and Index would be updated in column P. Any assistance you provide would be greatly appreciated.