Repeating a Macro across multiple worksheets....

[chefdt]

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

 

[venkat1926]

you can select all the relevant workhsheets and type the formula vlookup in one sheet in relevant cells and the formula will be copied in all the relevant sheets

how to select all the relevant sheets. If they are contiguous use shift key oherwise control key and select each of the tabs.

 

[ravishankar]

HI
try the following codes

Sub fill()
dim a as integer
for a = 2 to sheets.count
if worksheets(a).cells(2,10) = "" then
worksheets(a).cells(2,10) = cells(5,5)
endif
next a
end sub

run the macro. it will fill all blank J2 with E5
Now tell me which email ID you wanted there.
Ravi