Dynamically build a link

Is it possible to have cell A1 be a hyperlink to a concatenation of what is 
in cells B1 and C1?

Without VBA?

Thanks! 


0
hall (126)
3/15/2006 8:43:30 PM
excel 39879 articles. 2 followers. Follow

1 Replies
507 Views

Similar Articles

[PageSpeed] 48

=HYPERLINK(B1 & C1,"Test")

Cheers

0
3/15/2006 8:51:23 PM
Reply:

Similar Artilces:

How do delete Hidden Macros and excel links
Hi, I was wondering if anybody knew of an add-in that would delete hidden macros or excel links. I remember there being one but forgot where to download it for free. Thanks. Hi LT! To remove all code from a workbook: Chip Pearson: http://www.cpearson.com/excel/vbe.htm You need to look for the heading: "Deleting All VBA Code In A Project " To remove links you can use freely downloadable Addin FindLink from: Steve Bullen hosted: http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel...

service calendar in MS Dynamics 4.0
Does anyone knows how we can achieve the following requirement with MSCRM 4.0 In the service calendar in MS Dynamics 4.0 you are able to create new appointments and service activities. Appointments and Service Activities which are created will be present in the Service Calendar. To see all details of such a record[Subject(default Value)] you must open it. But by moving your mouse on the concerning appointment or service activity, a text-box-view appears with primary information. With appointments the content of the following fields is displayed: 'show time as', 'subject...

dynamic resource
Hi, Anybody know how to load e.g. bitmap into resource dynamicaly? The bitmap file will be downloaded by application itself , so it has to be somehow inserted into resource and displayed. thanks What do you mean by "into resoure dynamically"? Do you want to load a ..bmp file and display it? If yes, take a look at GDI+, which is by far the easiest way to achieve this. ---------- Ajay Kalra ajaykalra@yahoo.com I misspelled this, yes I'd like to load new bitmap on the fly. But resource file looks like is static. I use ATL/MFC applicatation. "Ajay Kalra" <aja...

Linking problem
Hi, when i try to compile my project i get the following error: LINK : fatal error LNK1104: cannot open file "dsprop.lib" Where is this file? What should i do? Regards Emmanuel Emmanuel, > LINK : fatal error LNK1104: cannot open file "dsprop.lib" > > Where is this file? What should i do? You need to update your platform sdk. http://www.microsoft.com/msdownload/platformsdk/setuplauncher.asp -- Regards, Kobi Ben Tzvi "Emmanuel" <e951753@hotmail.com> wrote in message news:090101c37874$9fcc1f40$a301280a@phx.gbl... > > Hi, >...

Dynamic sum in Chart
Hello: So I've got this pivot chart that I've created, and it's great, EXCEPT when I select different categories to show up, I want to show a SUM of the categories, not the values of each category. I would appreciate any help/advice you may have. Thank you! Michelle In the pivot table you can select different thing like count and SUM etc. If you right click in the upper left vacant square and chose field settings, then select what you want to see in your data section. Misha wrote: > Hello: > > So I've got this pivot chart that I've created, and it's great...

Folder-Link Icon in Outlook 2003
In the past (Outlook XP and before) I could distinguish between a regular Folder and a Folder-Link (.xnk file). Their icons were different. In Outlook 2003 a Folder-Link icon looks exactly the same as a Folder icon. Is they any way I can influence the look of Folder Link icons ? You can change the xnk-file icon association by going to Control Panel-> Folder Options -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -What do the Outlook Icons Mean? -Create an Office 2003 CD slipstreamed with Service Pack 1 ----- "Arie Blonk" <Arie Blonk@discussio...

can i use excel to generate web links
Hi, I work for a charity - we're going through our donors at the moment and have to search for each one individually in the charity commision website. I was wondering if there's a way of using excel, which already has our data in, to generate urls linking to the above site's (or any) search engine incorporating the contents of a cell. ie: i'm searching for dog the search page url is www.search.com/search=?? and want to genenerate www.search.com/search=dog I want to generate one of each of these for each donor any thoughts would be greatly appreciated thanks simon Maybe yo...

Anti-Phishing filter blocking many legitimate links
The anti-phishing filter in Outlook SP2 is a great idea but the implementation makes it worthless. It is blocking links in so many legitimate messages that I find I am allowing the link to be active almost automatically. Is there any information on what the criteria are for a link to be considered unsafe? How would the writer of a newsletter get his or her links off the verbotten list? there is no information on it - otherwise spammers would make sure theirs were not blocked. The only links I have blocked are ones where the hyperlink domains are mismatched. i.e., Sears uses cheetahm...

Linking to folders
Hope someone can help. I am trying to use excel to create a shortcut to our electronically stored files. Although I can use hyperlinks to link to specific files, is it possible to open a folder through a hyperlink or macro? Files are stored on a network and not on the hard drive in case this makes a difference. Thanks Sid -- Sidnoir ------------------------------------------------------------------------ Sidnoir's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25916 View this thread: http://www.excelforum.com/showthread.php?threadid=392893 I don't h...

SharePoint Alternate Access Mapping to my Dynamics GP BP site
Hello, If I have posted this question in the wrong forum please let me know! I’m looking for some guidance on changing the Alternate Access Mapping for my Dynamics Business Portal site. So I can implement Single Sign On via ISA Server which is supported on one web listener. Present configuration: Default Zone: http://geneva:222 I would like to add: Internet Zone: http://dynamicsbp.proclub.com I presently have another SharePoint Collection (The Main Portal) http://geneva configured which listens on Port: 80. I tried to add the Alternate Access Mapping http://dynamicsbp.proclub.com...

Tab seq dynamically...
I have a button which added dynamically to a property sheet. Now for setting the tab sequence with this new button, Am using SetWindowPos() method. Now tab sequence is proper. THE PROBLEM IS Through the arrow keys, I could not navigate to the last button for which I called SetWindowPos. where as through tab keys I could go to the last control. I will appreciate ur help in this. DETAILED DESCRIPTION I have three buttons (OK,Cancel, Help)on the property sheet. I added a button "Default" to the property sheet and positioned between Cancel and Help. I set the tab sequence as ...

dynamic charting #2
Hi I have to update a weekly spreadsheet With week numbers in column B x series and three y series percentages in G,H,I columns. Could someone please help I need these to update automatically. If someone can explain in detail I would appreciate 39 2097 2165 68 1770.7 97 96.86 118.43 40 2443.15 2201 -242.15 1548.93 97 111.00 157.73 41 2162.83 2259 96.17 1600.78 97 95.74 135.11 42 2163.08 2241 77.92 1545.1 97 96.52 140.00 43 2137.5 2271 133.5 1664.6 97 94.12 128.41 44 2160.67 2298 137.33 1455 97 94.02 148.50 Ta Brian ...

CRM Integration with MBS/Dynamics products
Hi, Anyone know anything about the integration between CRM 3.0 and ...say.... Dynamix AX/Axapta? I'm thinking sharing of customer data and such.... Jeppe Jespersen Denmark There is nothing available yet. You would need to build it. -- Matt Parks MVP - Microsoft CRM "Jeppe Jespersen" <jdj curly jdj dot dk> wrote in message news:OAfVImWLGHA.3276@TK2MSFTNGP09.phx.gbl... Hi, Anyone know anything about the integration between CRM 3.0 and ...say.... Dynamix AX/Axapta? I'm thinking sharing of customer data and such.... Jeppe Jespersen Denmark ...

Links to Attachments
Hello. I used to use Outlook 97. We had a large office that stored documents on a shated LAN. Instead of sending actual attachments, you had the choice of sending the document or just a link to it. You selected this from the same window you used to browse to your document. It did not require you to type an URL. It was very convenient. Is there a similar feature in Outlook 2003? It was so useful that I hope it is still there but I just can't find it. Thank You, Janice Lehman Yes, Outlook 2003 still does this. --� Milly Staples [MVP - Outlook] Post all replies to the group to ...

Dynamics GP 10 and Dynamics AX 4.0
just a half year ago, our company has started to work with Dynamics AX 4.0. Now i am doing some programming in X++ and almost customizing reports. Accidently, i stumpled on Dynamics GP 10.0 and i am wondering what s the difference between AX and GP? What stands GP for? Maybe GP is to replace AX, and our company backs to wrong horse? Does GP 10 contains AX 4.0? I have learnt lot of X++ programming, would it be possible to using X++ in the GT 10 field, too? Great Plains (GP) is another ERP system that Microsoft acquired a few years ago when it acquired the company of the same name. GP ...

Need a method to Dynamicly change the X axis Scale on a chart. #2
I dynamically change the amount of data on a chart. This causes the X axis Scale to either to either show too few values or too many values ( a solid black line if too many). I would like a method to dynamically change the scale values in relation to the data span. Joe - Do you want to limit the number of points displayed? http://peltiertech.com/Excel/Charts/Dynamics.html http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246 Or do you want to link the axis scales to something you calculate in the sheet? http://peltiertech.com/Excel/Zips/SwitchXYAxes.zip - Jon ----...

Dynamically populate a drop down list
Hi, I'm trying to dynamically populate a drop down list in MS CRM (1.2) based on certain parameters. I suppose I could do it using a SQL stored procedure, but I would prefer to use standard/supported CRM customizations. Any assistance in this would be greatly appreciated. Thanks! -Dave- Dave, You can do it in 3.0 pretty easily based upon an example in the SDK... Here are some pretty pictures... http://blogs.msdn.com/midatlanticcrm/archive/2005/12/04/499868.aspx I have not tried it with 1.2, but it could probably work... Thanks Ben "Dave" <renor321@yahoo.com> wrot...

Web link to Excel file
I'm trying to link to an Excel 97 file from a ColdFusion web page. The first time I click the link, the file opens fine in the browser (I.E. 5.5). If I close the file and click the link again, I get a message stating 'filename.xls is currently being modified by "my user name here". Open as read only?'. I can still open the file as read only, but am wondering why I get this message, because I'm not making any modifications. I've had other people try this link, and they get the same thing, except it tells them that they're the one modifying the fi...

Link to a cell and text in same cell
My Sheet: A1= BOB I want B1 to equal the value in A1 and additonal normal formatted text so it would read "BOB's Total". I've searched all thru the help and cant find a good example to lead me into anything like this. Anyone have any ideas? ::CORY:: Have a look a this: http://cjoint.com/?cxrxFU3ubq. HTH, -- AP "::CORY::" <no_ka_oii@hotmail.com> a �crit dans le message de news:%2314mDPJOGHA.536@TK2MSFTNGP09.phx.gbl... > My Sheet: > > A1= BOB > > I want B1 to equal the value in A1 and additonal normal formatted text so it > would re...

CRecordSet is readonly in UNICODE build
Hi When using Visual Studio.NET 2003 to compile code that uses CRecordSet to open a table, the recordset is opened read-only in UNICODE builds. If the project settings are set to use MBCS, the recordset is read-write. The recordset is opened as a snapshot, however, if it is changed to dynamic, it works correctly. The above happens when creating a new C++ project or compiling old (VC 6.0) code. It works correctly in VC 6.0. Thanks Pierre-Andre ...

Dynamic Range
Hi All, I have the following two dynamic ranges =OFFSET(PBR!$A$1,0,0,COUNTA(PBR!$A:$A),1) =OFFSET(PBR!$A$1,0,0,COUNTA(PBR!$A:$A),2) Note: there will be two ranges namecount & namelist The formula which would be using the above range is =IF(MAX(namecount)<ROW(1:1),"",VLOOKUP(ROW(1:1),namelist,2)) Big question!!!, can I join these ranges together in to one statement. if so than how ??? Thansks, Rashid Hi! If I follow what you want: Named range: List Refers to: =OFFSET(PBR!$A$1:$B$1,,,COUNTA(PBR!$A:$A)) Then: =IF(MAX(INDEX(List,,1))<ROW(1:1),"",VLOOKUP(R...

dynamic menus
I want to be able to create a hierarchy of menus under the view menu. I don't know at design time how many items will be under each submenu. I have been able to access and add to the view menu itself. By I have not been able to add anything under that added menu. I know it shuold be a popup menu. but when I make it a popup, I get an assert when I try to open the view menu. Here's what I have so far (some experimentation still remains): m_pWndMenu = GetMenu(); //int count = m_pWndMenu->GetMenuItemCount(); //CString string; //m_pWndMenu->GetMenuString(2, string, MF_BY...

VISIO Gant Chart: Link 2nd page to 1st page project timelines
I am trying to create a GANT chart in VISIO that is multiple pages. The first line on the first page is the main project "title". I need subsets of the project to link up to the main project line. When I move to "page 2", it starts over again, instead of linking those tasks to the original plan. ...

Building the required SQL statement
Hello, I'm having difficulty writing a query and was hoping someone could help me out. I have a table 'orders' which contains numerous fields, of which 3 are of particular interest to me 'order_status', 'clientid1' and 'clientid2'. I also have a table 'clients' which has a primary key 'client id'. What I am trying to do is return all the data from the 'clients' table for the associated clientid1 and clientid2 where the order_status="conf". I get lost because of the need to get the info for clientid1 and clientid2. ...

Creating a dynamic chart
I posted here a few days ago and was given some ideas on how to do this. However, I seem lost. I have a main worksheet which is updated from several worksheets by using code. On this worksheet is approximately 15-20 columns something like this. trimester year RW RW% WIW WIW% etc 1st 2001 80 89% 79 75% 2nd 2001 90 89% 84 87% 3rd 2001 87 88% 92 89% 1st 2002 88 88% 90 88% etc etc What I would like to do is create one chart and by selecting the title of the column from either a combo box or by using a bu...