![]() |
List - Hyperlink - Template - Email
Hi Wise Ones...
A daily shipping list is provided ea morning (Daily.xls) * Ref No. * From * To * Qty * Wght * Due Date I'd like to set up macro to 1) Auto Hyperlink ea Ref No. row A (daily.xls) to Template (alert.xls) 2) Link value chosen/clicked (daily.xls) to cell A1 (alert.xls) 3) Index/Match A1 (alert.xls) to remaining fields... retrieve other specs. i.e.. B1= index([Daily.xls]$B:$B,match([alert.xls]$A$1,[Daily.xls]$A:$A,0)) 4) Auto Setup to E-Mail Body (alert.xls) 5) Auto fill E-Mail Subject line with A1 value (alert.xls) Task 3 can handle on my own but the others have proved difficult to figure out on my own. Any assistance appreciated Brgds in advance, Steven |
List - Hyperlink - Template - Email
** CORRECTION **
1) auto hyperlink ea ref no. COLUMN A .... Hi Wise Ones... A daily shipping list is provided ea morning (Daily.xls) * Ref No. * From * To * Qty * Wght * Due Date I'd like to set up macro to 1) Auto Hyperlink ea Ref No. row A (daily.xls) to Template (alert.xls) 2) Link value chosen/clicked (daily.xls) to cell A1 (alert.xls) 3) Index/Match A1 (alert.xls) to remaining fields... retrieve other specs. i.e.. B1= index([Daily.xls]$B:$B,match([alert.xls]$A$1,[Daily.xls]$A:$A,0)) 4) Auto Setup to E-Mail Body (alert.xls) 5) Auto fill E-Mail Subject line with A1 value (alert.xls) Task 3 can handle on my own but the others have proved difficult to figure out on my own. Any assistance appreciated Brgds in advance, Steven |
List - Hyperlink - Template - Email
"SteveT" wrote:
** CORRECTION ** 1) auto hyperlink ea ref no. COLUMN A ... Hi Wise Ones... A daily shipping list is provided ea morning (Daily.xls) * Ref No. * From * To * Qty * Wght * Due Date I'd like to set up macro to 1) Auto Hyperlink ea Ref No. row A (daily.xls) to Template (alert.xls) 2) Link value chosen/clicked (daily.xls) to cell A1 (alert.xls) 3) Index/Match A1 (alert.xls) to remaining fields... retrieve other specs. i.e.. B1= index([Daily.xls]$B:$B,match([alert.xls]$A$1,[Daily.xls]$A:$A,0)) 4) Auto Setup to E-Mail Body (alert.xls) 5) Auto fill E-Mail Subject line with A1 value (alert.xls) Task 3 can handle on my own but the others have proved difficult to figure out on my own. Any assistance appreciated Brgds in advance, Steven |
All times are GMT +1. The time now is 12:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com