hyperlink builder

Hello, I'm trying to find a seamless way to change the data source file in a pivot table without manually going in and editing the text via Pivot Table Tools -> Options -> Change Data Source. Ideally, I would somehow build a reference using a HYPERLINK-CONCATENATE formula that I build, either...

Thank you for your time. I am a realbeginner in the VBA and I am asking for your help for the next issue. I have <o:p></o:p> A sheet called "START" in which anActiveX ComboBox named ”CLIENTI” is inserted,<o:p></o:p> and<o:p></o:p> A sheet called "CLIENTI" in whichthe Range ”B3:B100” contain...

I have a large excel file with ~100 tabs. Between each grouping of tabs (by region), I have placeholders with no data but simply the region name to facilitate adding across the file. When I want to edit all of the data tabs at once, I have manually select all of them, or else choose all tabs...

Hi, I have a spreadsheet with numerous tabs, that links into a system we use. The 1st tab is coding that pulls information from the system and populates the second tab. We then format the data and use formulas to provide a report on the 3rd tab. The issue I'm having is that part of this...

Hello, I have created a hyperlink on my spreadsheet with CONCATENATE, and it opens the file from my server just fine. It resides in G4. In H4, however, I would like to have a formula that pulls a value from that hyperlink in G4. I have this formula: ='[G4]2-4-16'!$I$4, but Excel still makes me...

I am creating several books that have several worksheets and each sheet needs a link to a summary sheet. I am lost trying to create a macro that will do this. If in addition, I could run a macro that will insert a hyperlink from the summary sheet back to each worksheet... that would be...

I have a folder containing an excel spreadsheet that lists numerous document numbers that relate to corresponding pdf images in the same folder. I need help converting these document numbers in the spreadsheet to hyperlinks that will open the appropriate pdfs. An additional challenge is that...

:eeek:hi i would be greatful for your help, i have an excel 2010 worksheet with the details of my karaoke tracks( artist track etc) the tracks themselves are numbered ZM00001..2..3 etc these details are also in the excel doc. I know i can use a hyperlink to just click and go...the problem i...

Hello, I have a list of Patent numbers in an excel sheet. I just wanted to know if following is feasible in excel: 1. I need a script so that each of the respective patent number (there 'web home page address' e.g. Patent number: 4456785 http://www.google.com/patents?id=jzs...ed=0CC8Q6AEwAA)...