If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If text then email macro
Hey all,
I am looking to create a formula or a macro that will email information from a row based on whether there is text in a certain cell in that row. And apply this solution for every row that will contain text in that column. I've been using Ron de Bruin's macro (VBA code) to set-up the email, which works perfectly to create individual emails based on the information, but I'm hoping to have this automated based on whether any text is present or not, and have this apply to each row. A possible issue is that the text in this cell is based on information from another sheet and will not show up on the active sheet until it is entered on the indexed sheet. Ie. =IF(ISNA(MATCH(ROW(A1),Main!K:K,0)),"",INDEX(Main! B:B,MATCH(ROW(A1),Main!K:K,0))) I hope I've explained this well enough...Any help would be appreciated! Thanks. |
Thread Tools | |
Display Modes | |
|
|