Hyperlinks Link To Other Worksheets
Nov 25, 2009
I have managed to find some code which, upon pressing a command button on the 1st worksheet in my workbook it:
1. populates a list of the names of all the other sheets in the document
2. converts each name into a hyperlink that when clicked, opens the sheet. (or at least it should)
3. Add the word 'menu' in cell A1 of each sheet that is a hyperlink back to the menu sheet
There are around 40 sheets in the document so you can see why this is easier than scrolling along the bottom to find the correct one. Or it should be.!
View 3 Replies
ADVERTISEMENT
May 16, 2008
I have copied and pasted a big table to excel. All the images have links and I need to extract that URL and post on it's own cell.
I have tried some hyperlink extracting code but I realized the images are not necessarily in a cell.
Is there a way to do this?
and by the way, is the a way to make the images show? I know they are there but they don't show.
View 9 Replies
View Related
Jan 16, 2009
Just need to delete some hyperlinks in column A on 50+ worksheets. Thought a loop through all the worksheets would do it. Only works on active sheet. Forgive my ignorance, don't really even know where it goes, once it works - module or workbook?
View 2 Replies
View Related
Mar 7, 2014
I have a spreadsheet that I have various formulas and sheets. To simplify:
Sheet 1: Columns A & B have Name and Code Number. I can add additional names and code numbers to these two columns whenever necessary.
Example:
Tom 874
John 385
David 712
Hidden in adjoining columns are formulas to automatically sort them via Code Number. Next to that are the columns showing the sorted information, sorted by number.
John 385
David 712
Tom 874
Additionally, I have a seperate sheet for Tom, John & David. Since I put Tom in first, he's Sheet 2. John is Sheet 3, and David is Sheet 4. I can use hyperlinks so when I click on John, it goes to Sheet 3; David Sheet 4; Tom Sheet 2.
Now, let's say I add Kevin 192 to the next row. The hidden columns are set up so that it'll automatically resort Kevin to the top, with John, David & Tom in the next rows down.
The issue I have with the hyperlink is that it's cell specific, not content specific, as far as I know. I would like the hyperlink to move with John's info so that it would still go to Sheet 3. Same with David and Tom. Unfortunately, after the resort, If I clicked on Kevin's name (which is now at the top of the list), it would go to John's sheet, since the hyperlink is attached to that cell.
How to allow a hyperlink to remain with the content, versus the cell? I would prefer it to be not a macro, but I'll take a macro over nothing!
View 6 Replies
View Related
Apr 29, 2008
I have a spreadsheet of various works-in-progress items, the first three columns of which refer to relevant documents, effectively the request, the estimate and the work order, i.e. RXXX-0001, EXXX-0001 & WXXX-0001.
So the text is entered as above (without file extension as it's also our reference number), and I'd like each to be linked to their respecive .doc files, which are held in different locations, i.e. \servernamefolderRequests or Estimates or Work Orders
e.g. \servernamefolderRequestsRXXX-0001.doc
There's a backlog of over 300 items (so 900 links) so I don't want to go through and manually create the links and as each day can see over 12 items being created it'd be much easier to have it done at the click of a button
Most of the solutions I've seen involve creating a new cell/button with the hyperlink in it - I just want to effectively "right click, create hyperlink" but with the cell contents inserted as the file name (adding ".doc") and with correct folder name too.
FYI the cells are adjacent to one another e.g. A1, A2 & A3 so the selection can be Offset (0,1) for the estimates and work orders.
I don't mind if it ends up being a case of running the macro on each line - some links have already been created already.
View 9 Replies
View Related
May 25, 2013
I have a worksheet with with links to other workbooks. This has been working fine but a few days ago stopped working. I am getting a pop-up box.
An example of this is : Opening C:Business300635 Invoice.xlsm.
Some files can contain viruses or otherwise be harmful to your computer. It is important to be certain that this file is from a trustworthy source. Would you like to open this file? Yes or No.
When i click on Yes the busy icon appears for about 2 minutes and then disappears, not opening the file. I have tried to get this solved by going to Microsoft site for any possible clues. no luck there. I have uninstalled all updates to Microsoft and Excel to a point prior to the problem occurring, but to no avail. I can access the workbook I need to open by clicking the Office Button, and then searching for the relevant workbook.
The hyperlink formula I am using is " =HYPERLINK("C:Business"&P546&" Invoice.xlsm", "Invoice") ". The "&P546&" refers to the invoice number listed elsewhere in the worksheet.
View 2 Replies
View Related
Apr 25, 2008
I have developed a template with tabs for Jan thru Dec, and a Template tab that has the report. the VB code copies the file as a new workbook whenever the year changes, creating something linke 07_Reports.xls. It also copies the "Template" to each Jan-ded tab and adds descriptive info to indicate that it is Jan or Feb etc. There are several sheets, and each has 3 or 4 different reports across the columss. each report has a month by month summary at the top,and daily details for each month down below, with each month detail beginning at 100 row intervals and having a row for each day of the month. i use the month names at the top as hyperlinks to jump to that month's detail.
when the file is created the hyperlinks are not copied from the template tab to each Jan-dec tab. Is there a way to have the Template tab use some type of Relative Reference.
If not is there a way to loop through the Template sheet and identify the properties of all the hyperlinks that exist on the sheet. I have over 30 of these Report templates, one for each Water Well that is involed in this project.
so..
1 - can hyperlinks be relative so that they copy and setup on different worksheets when copied.
2 - if not is there a way to read thru the rows/columns of the worksheet and identify which cells in the template have a hyperlink, get the properties of it, and have vb code create that in the crated tab worksheets.
View 3 Replies
View Related
Apr 11, 2013
I have workbook with worksheet 1 and worksheet 2. I need to creat a link on Worksheet 1 so that when you click it it will take you to worksheet 2
View 1 Replies
View Related
Apr 7, 2008
I would like to link a sheet to another sheet in the same workbook. The link would indicate what week of information is needed. I would like the source (weekly information )page to go to the top of the page with the requested data. If I use a hyperlink it directs to the source page but this data could be several rows down. How do I create a link and have the source page provide the data at the top of the page?
View 6 Replies
View Related
Feb 28, 2009
I work for an IT company who build their own PC's. And we use a simple Excel 2003 spreadsheet to piece-together and price-up PC's for retail, I've attached an example of the spreadsheet for you to see. It uses basic formulas so we can see at-a-glance things like VAT figures, margin, profit etc. Each PC we sell is contained within one Excel file, and each PC has it's own Workbook tab.
The problem I want to solve is whenever we change a component or price, we have to do each system manually, which gets very repetetive and time consuming. What I'd like to be able to do is change the price of, let's say, the motherboard, and have the price be reflected across each of the PC's using that same motherboard on each seperate tab. This same system would apply when we change a product name, product ID etc.
View 2 Replies
View Related
Jul 11, 2012
I need to link information between two sheets.
In Sheet2 I have a list of products with their description in adjacent columns such as prices and other information. Sheet1 is a MasterSheet of some of the products listed in Sheet2. So I would like to write a macro that links the information of the product from Sheet2 to Sheet1 if I type the products name in Sheet1 (MasterSheet). The list of products (Sheet2) is updated in a regular basis, so by linking the info I would just need to update Sheet2 and Sheet1 would update as well.
View 4 Replies
View Related
Jan 17, 2007
on a workbook I use.
The workbook (26-11GL.xls) contains a varying number of sheets.
Sheet 1 - Menu
Sheet 2 - DS1
Sheet 3 -DS2
Sheet 4 -DS3
Sheet 5 - DS4
Sheet 6 - Company1
Sheet 7 - Company2
Sheet 8 - Company3
Sheet 9 ....14 Company 4,5 etc
Sheet 15 - CompanyTotals
What I would like to do is when I open the workbook on the Menu page I would like to have some links / buttons that will automatically create a new worksheet called DS5 which has all the formatting, formulas etc from DS4 (or the last complete DS sheet)
If this is possible I would like to be able to add Company worksheets as both DS sheets and company sheets can have from 3 to 35 sheets in either area.
If possible I would like the new DS sheets to be named with the next valid number.
View 6 Replies
View Related
Oct 6, 2009
I have a workbook with multiple worksheets, recording time in and time out of temporary employees. The first worksheet is a summary of each weekly timesheet. I would like to make it so the names only have to be typed once and will fill in on the subsequent sheets. I linked the cells, but since the employees may not work every week--we do not know in advance whether they should be included on the time summary at the beginning of the month.
Time Summary Worksheet
Last Name..First Name..Reg Time..OT
Bilson.........Bill.............40..........12
Samson......John...........40..........5
Time-Week 1
Last Name..First Name..Day1..Day 2, etc.
Bilson.........Bill.............12....14
Samson......John...........8.....10
Time-Week 2...
The problem comes when I try to add a row for a new employee. If I add it to the Time Summary worksheet all the data in the Weekly timesheet worksheets is thrown off.
Time Summary Worksheet.......................
View 4 Replies
View Related
Feb 18, 2008
I would like to write a macro that links cells in one workbook (working) to cells in another workbook (summary).
I don't want this to be a straight swap thought, I'd like it to contain the following formula:
=IF(Working!G8="a","a","")
The cells in the working workbook are listed vertically, while the cells in the summary workbook are listed horizontally.
ie. link G8-G18 in working to B3-K3 in summary
link H8-H18 in working to B4-K4 in summary
...etc
View 9 Replies
View Related
Oct 9, 2008
I want to make a lookup on a string of words from one of my worksheets and I also whant to make a hyper link so that when I click on the lookup command I should pop to the other worksheet were my database is.
View 2 Replies
View Related
Dec 31, 2012
What can I do to link my worksheets together? I need the months to link from january to december.
I'm trying to come up with a system to maintain attendance of employees. How do I come up with a rolling system to add and deduct the points as their attendance changes? The goal of each employee is to have the least amount of points as possible, because he/she will be penalized once they receive a certain amount of points.
Let's say that Jane was hired in October. She has accumulated 10 points by December from tardies, call-ins, etc. By the end of January, she has perfect attendance; she is awarded half a point to be taken off toward her 10, giving her 9.5. In February, there is a day she does not show up, so now her total goes up to 12.5 (3 pointed added because of NCNS-no show no call). In March and April, she has perfect attendance, so now her total is 11.5. (half a point allowed for each month with perfect attendance)
By rolling, I mean a formula that will calculate continuously over month after month and have the points roll over month to month.
View 9 Replies
View Related
Jan 27, 2010
I'm in need of a formula, or another automated technique, to link a column of data from one worksheet to another. I have an input worksheet that I copy the raw data into that is formatted as follows:
COLUMN A
Row 1 12001
Row 2 12004
Row 3 12011
Row 4 12020
Row 5 13050
etc...
I need this import sheet to link to an output worksheet that would be updated automatically as new data is entered into the input sheet. However, I need the output sheet to copy the input values a specified # of the times and list them. For example, if the specified # was 3, it would be formatted as follows:
COLUMN A
Row 1 12001
Row 2 12001
Row 3 12001
Row 4 12004
Row 5 12004
Row 6 12004
Row 7 12011
etc...
I need the formula, or method, to be one that I don't have to continually re-enter as the data changes, as I have thousands of records to do this with. I've tried filling down, but autofill doesn't recognize an accurate trend. Is this something that I can accomplish by combining several fomulas, creating macros, or a combination of the both?
View 2 Replies
View Related
Feb 21, 2007
I have a spreadsheet and within the first sheet there are lots of hyperlinks to other cells within sheet 1 (my template).
I have made a small macro which very basically makes a copy of sheet 1 (my template)
The hyperlinks in the template are explicit and as they are copied to sheet two, they still reference back to cells in sheet 1. I need the hyperlinks to be relative, so that when I make a copy of the template the hyperlinks are copied and make reference to cells in the new sheet. I cannot work out how this should be done
View 6 Replies
View Related
Jun 28, 2013
I have two worksheets, one with detail monthly information and one with YTD information. So let's say the three numbers I want to capture in the YTD sheet are in columns B, G and I on the monthly sheet. January's data might be in B5, G5 and I5. February's data is in B12, G12 and I12 and so on.
On the YTD sheet in cell C2 I link to Monthly!B5 and in C3 I link to Monthly!B12 so cells C2 to C13 on the YTD sheet show the monthly totals from column B on the detail sheet. On the YTD sheet, cells C20 to C31 show the monthly totals from column G on the monthly sheet, so cells G5, G12, etc. And finally, cells C40 to C51 on the YTD sheet show monthly totals form column I on the monthly sheet.
In the past I've always created all these links manually. After creating the links in C2 to C13 on the YTD sheet, is there a way to use a formula in C21 that uses the link in C2 to create a link for G5?
View 6 Replies
View Related
Jan 26, 2008
I have a spreadsheet that when an identity code is keyed in, it will display a make and model of a particular mobile phone, i want to put a hyperlink in the cell next to the phone name which will then open up an IE window to a website.
The thing i want ideally is if there is any way you can incorporate the websites search function into the hyperlink so when you click on it, the hyperlink will copy the phone details over to the website's search engine and take you straight to the online details of the phone?
wow this isnt making sense to me!
For e.g
The identity code shows up a Nokia 1500
The hyperlink next to it takes in the manufacturer/model details "nokia 5300" (these will obviously vary each time so takes in a cell reference should i say)
It opens up the ie window e.g "google" and automatically searches for that "nokia 5300" and comes up straight away with the search results.
View 9 Replies
View Related
Feb 4, 2010
Is there a way of using something like hyperlinks in VBA code to open a user form?
I presently am using hyperlinks for coworkers to open other pages that resemble a user form.
I would like to change this to actually using user forms.
I would prefer to simply click on a person's name and open the form.
View 9 Replies
View Related
Jan 31, 2013
I need returning a working hyperlink from a vlookup. I have a table with part #'s and hyperlinks. On another tab I want to type in a part number, have it search the table and return the working hyperlink. This will allow the user to just click it and go to that tab.
Here is my example spreadsheet : Book1.xlsm
View 2 Replies
View Related
Jun 20, 2008
I created a data base that had a hyperlink to a plan of the store so we can find parts easy. With a lot of help for people here on this web site, it works very well.
My only problem now is that I sorted my Database by the hyperlink column. It made it easy to do one hyperlink and pull the fill handle down for the rest of the same hyperlink reference.
When I went to resort the database so that the parts were in alphabetical order. The sort worked well except that the hyperlink for lets say cell F87 was not sorted. Example : - F87 hyper link presort had the reference to Rack 10 self B. Post sort it had the reference to Rack 16 shelf C. But when clicked on it still took you to Rack 10 self B.
View 11 Replies
View Related
Jun 9, 2009
When I click on a hyperlink inside an Excel spreadsheet, it is linked to a PDF file. When clicked, the screen flashes the Adobe Acrobat program for a split second and then disappears. But I can open the hyperlink same as which it is linked to a word file in the same directory.
I have gone into folder options and switched the PDF to open with Adobe reader 8, but that does nothing.
Any ideas of how to get the PDF to open and stay open would be most appreciated.
I tried to install adobe reader 4.0 without uninstall adobe 7.0 professional.
I use pdf reader 4.0 open the Pdf file in the window explorer, and then go to excel, open the same hypelink pdf file, and find it works now only opening pdf document by pdf reader 4.0 but not by 7.0.
But when I resinstall adobe 7.0 professional, and the problem still occurs. I have to open the original pdf file in the directory by adobe reader 4.0 again.
My case is like the following Macro in excel.
Setup hyperlink and open it . Then the problem is shown as my previous thread mentioned.
Sub Review() .....
View 6 Replies
View Related
Jan 21, 2010
The following is a simplified example of my problem: I have a list of product item numbers in column A. Next to each item number in column B, is a hyperlink to a PDF file relevant to each item. Elsewhere in the sheet, is a drop down box containing the item numbers. Next to the drop down box is a HYPERLINK(VLOOKUP) that fetches the relevant hyperlink depending upon the selected item in the drop down box. Problem is, when I select the ‘lookup’ link, I get an error message ‘cannot open the specified file’ (the original Hyperlink works fine). Does anyone have a solution to this problem (preferably without resorting to Visual Basic?
View 13 Replies
View Related
Mar 12, 2009
I have a database of two columns - a file name and a hyperlink for the folder path to that form. What I would like to do is a VLOOKUP type search by the form name and the result be the hyperlink itself. The problem is that vlookup basically provides a "Values Only" response and doesn't carry over the hyperlink format.
View 2 Replies
View Related
Sep 8, 2009
I made the mistake of creating hyperlinks to files on a server (using the \SERVERNAME convention) without using the "hyperlink base" option.
I've been sufficiently chastened, but the present problem is that I have many such hyperlinks that are now worthless because, when saved, they point to "../../[foldername1]/[foldername2]/[filename]", etc.
Need macro that would replace the first five characters ("../..") of all the hyperlinks on my sheet with //[MYSERVERNAME] ?
View 7 Replies
View Related
Oct 9, 2009
how to use a combo box to select hyperlinks to take you off to the selected website? I have this, which works but it's hard-coded - I'm looking for something a little more dynamic, i.e. pick up hyperlinks from a range on a sheet.
View 2 Replies
View Related
Jan 13, 2010
Can a message box support a hyperlink? I prompt a user with a message box with the text to a website, can the text for the website be a hyperlink in that message?
View 2 Replies
View Related
Feb 2, 2010
Have the following dilemma in Excel: If I enter a value in cell A3 and the value corresponds to a reference value in one of cells B4:B12, can I hyperlink data in cell range C4: C8 to elsewhere on the sheet (eg J4: J8).
Example.
I have 8 meeting rooms that each have a dedicated code, AU, BR, FOR, TO, M1, M2, M3, M4
When I enter a code in cell A3, (eg AU) I want the data in cells A4: A8 (date, start, end, event) to be reproduced in another table on the sheet.
In other words: If A3 is equivalent to a value in cells B4: B12, then can data in C4:C8 be reproduced in J4: J8?
View 6 Replies
View Related
