Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info

I am working with Excel 2002 in a Windows XP environment.

Doing a hyperlink from within my Customer Contact Info Worksheet
directly to the "Get Directions" screen at MapQuest was really simple
with the hyperlink insertion utility on the Insert Drop Down Menu.

However, since we have the computer doing all the work shy of a click
of the mouse or a tap of an Enter Key, why not have the hyperlink
address include the necessary references to automatically load the
Customer's Street, City, State and Zip Code with that same press of
the finger?

My Worksheet is entitled 'Customer Contact Info'! when linking within
the Workbook.

My Worksheet was set-up with small width cells due to the various
other pieces of Contact information. The full width of the sheet runs
from cell A to cell AH thus, the MapQuest input comes from the
following cells:

Street Name: Cells H45:AG45 MERGED INTO A SINGLE ENTRY FIELD.

City Name: Cells H47:AG47 MERGED INTO A SINGLE ENTRY FIELD.

State Name: Cells H49:T49 MERGED INTO A SINGLE ENTRY FIELD
which is MUCH WIDER than necessary.

Zip Code: Cells X49:AB49 These are INDIVIDUAL CELLS
for the first five (5) digits

and, Cells AD49:AG49 are INDIVIDUAL CELLS
for the last four (4) digits

I have tried editing the hyperlink formula using

1) the Merged Cell ranges AND
2) the first Cell of the Merged Cells BOTH
3) WITH and WITHOUT the Worksheet Name.

But, this information in any one of these formats is simply
transferred to MapQuest in their literal structure rather than loading
the information within the cells as would be done from Worksheet to
Worksheet within Excel.

How do I structure the hyperlink formula to load the true address
information as it is entered into the various cell ranges to be
recognized by the MapQuest search engine for directions?

I do have to be careful in regards to the length of my Cell ID because
there is a 255-character limit to the hyperlink formula.

Hoping that this solution is as simple as the last one I asked for.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't merge info from Excel onto address labebls dflowers Excel Worksheet Functions 1 April 28th 09 04:44 PM
How do I avoid excel change absolute address to relative address Miguel Excel Discussion (Misc queries) 3 May 10th 07 11:18 PM
excel problem: sum(address(4,2,1):address(2,1,1)) DrSlowpoke Excel Discussion (Misc queries) 2 December 22nd 06 03:50 AM
Email address in excel spreadsheet Rich K. Excel Discussion (Misc queries) 0 November 21st 06 06:02 PM
excel spreadsheet into address labels maxime Excel Worksheet Functions 4 November 4th 05 03:49 AM


All times are GMT +1. The time now is 05:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"