Creating a dynamic URL based on other cells values

  • Thread starter Thread starter juliuss
  • Start date Start date
J

juliuss

Hi all.

I would like to create a clickable link in Excel. I want this link to
include the values in other cells as parameters. So, for example:

Cell A1: 123
Cell A2: abc

Cell B2: ="http://server.com/page?a1="&A1&"&a2="&A2

So, this clearly would display: "http://server.com/page?a1=123&a2=abc"
but the link is not clickable. I'm looking for an easy way to make the
data in this document upload to a web server -- maybe there's something
I can do here that would work, or maybe another trick?

The reason I'm trying to avoid VBA is because it seems to break often
and because emailed macros are often stripped of their code. However,
it looks like it may be the only way.

My question then is
1) can this be done without a macro in some clever way?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Lookup function to cell containing multiple values 3
Displaying a range based on a cell's contents 3
Data Validation and drop-down list using IF, AND and what else? 8
3 simple(!?) problems: activate cell concequence / text formulas 9
look to a cell for a reference to a sheet 2
Excel - cell address inside formula as text from other cell 5
Using multicell range when single cell prescribed 2

Back
Top