attaching files

mlw901

New Member
Joined
Oct 28, 2002
Messages
41
Can i create a drop down list of links on a spreadsheet because i need to be able to, for example, select a title of a cd from the list which will then provide a link to an attached word document of its details.I then need to be able to send this spreadsheet as an email with the attached document.Help!
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
You need to create your list (don't bother to make them hyperlinks). Use a combo box and link it to a cell - so whatever is selected appears in a cell. Then have another cell that is visible to the user that then creates the hyperlink....

e.g you pick CD - "Parachutes" and link the box to cell G8

In G8 you then get "Parachutes"

In say A4 you have a formula:

=HYPERLINK(G8 & ".doc","CLICK HERE TO GET MORE DETAIL ON YOUR CHOICE")

For the email - use G8 & ".doc" to attach the file.

This help?
 

Forum statistics

Threads
1,144,275
Messages
5,723,449
Members
422,497
Latest member
dougy99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top