Spratt_Cary
01-11-2010, 12:38 PM
I have a Workbook Test2.xls with 2 worksheets: Sheet 1 and Data. WorkSheet "Data" Column A has a list of numbers. If one of those numbers appear on WorkSheet "Sheet 1", column A, then I need for the indication in WorkSheet "Sheet1" Column C to populate on WorkSheet "Data", Column G. Example: Number 13074 appears in WorkSheet "Data", column A from row 519-547. Number 13074 appears on Sheet 1, column A with indication of Hepatic Disorders/Liver - Hepatitis B. This indication "Hepatic Disorders/Liver - Hepatitis B" now needs to populate sheet "Data" on rows 519 to 547. See attached worksheet.