I have work sheet (MAS) with (SALESID) in the first column, and (EMAIL) addresses in the 5th column.
The workbook has many other sheets, that get data from (MAS).
I need a macro that will look at each worksheet, and populate (J2) with an email address from column 5 on (MAS). If (J2) is blank, I need it to move on, and continue with all worksheets.
Any help would be appreciated.
DALE
The workbook has many other sheets, that get data from (MAS).
I need a macro that will look at each worksheet, and populate (J2) with an email address from column 5 on (MAS). If (J2) is blank, I need it to move on, and continue with all worksheets.
Any help would be appreciated.
DALE