ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   List - Hyperlink - Template - Email (https://www.excelbanter.com/excel-discussion-misc-queries/191563-list-hyperlink-template-email.html)

SteveT

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

SteveT

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


SteveT

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