1. SkyGod

    From Listview to Listbox

    Hello, I want to give connection when a data selected in listview to listbox. I mean double clicked a data in listview must be also selected in listbox by automatic double clicked way. Every rows have a UniqueID after saved. Thank you for help. Download Link
  2. B

    VBA Code needed to add a link to cell on another tab in the same excel file

    Hi Excel Gurus!!! I simply cannot figure this out so I am looking for help on the following: Workbook Setup • Workbook Name: PatientList • Sheet1 Name: Patients • Enter "TestPatient1" in cell A1 on Patients sheet • Right click on cell A1 • Click "Link" on the drop down and then click...
  3. A

    Links for filepaths too long (+260) fix?

    Hello, I have designed an Index for a repository of documentation in which every cell has a Link to open the corresponding file. It all works wonderfully until the paths start getting longer, since there are docens of directories and subdirectories deepness. Is there any way so the link can...
  4. M

    Other version of Hyperlink

    Hi. In advance, sorry for my english. I want to link value to other excel when i click cell i dont want to go other sheet for explain, i want it show when i aproach to cell. Please look at images
  5. H

    Link multiple dropdown lists to always show the same value

    Hi all! Your help with this would be greatly appreciated. I have 2 dropdown lists using the same source. When the value in either List 1 or List 2 is changed via the dropdown, I want the other to change to match. I've got it working for one using the below VBA code, however, if I repeat the...
  6. E

    Hyperlink using a column as reference.

    Hi, My data looks something like this: A B C 1 Name: Date Of Birth: Reference: 2 SMITH, John 12/03/1988 K3472 3 JONES, Kayla 27/04/1962 K7895 4 RUSS, Tim 08/07/2022 I want the names (A2:A4) to be hyperlinks using the data from Column C. The link to the website...
  7. A

    Links from Excel to PowerPoint break

    Hi everyone, I am having some trouble regarding linked charts copied from Excel into PowerPoint. I am working on a powerpoint template, with several charts created in a separate excel file (located in the same folder). I want to be able to update the excel file, and for the powerpoint to...
  8. Jyggalag

    Please help me create an IndexMatch-like formula

    Dear all, I am currently sitting with a rather large sheet of data. I have made a smaller, and more simple data sheet for simplicity's sake. Currently I have the following information: As you can see, the data for 2016 has already been filled out (through an old and more manual method)...
  9. J

    Opening a image within excel

    I have an excel file which lists the stamp sets that I have. This catalogue is used to locate a particular stamp. I want to be able to open an image file associated with that stamp set. I am using the "insert link" function. This works after a fashion ... ie: it works only for that...
  10. Z

    Make link added to object dynamic based on worksheet name

    Hi everyone, I hope someone could help me with this query. I am working on a file with a 'Summary' worksheet with a table that lists all other worksheet names present within the workbook (see screenshot below). On one of the other worksheets (VCNA.PIV1), I've added a grouped object (see...
  11. H

    Content of the link available on computer

    Hello everybody. Long story short: I have two worksheets. On the first one, a have a table with two columns: "Layout Code" and "Layout Plan". The "Layout Plan" column contains a link to an internal document (PDF, PNG, etc.). On the second worksheet, I have a dashboard where I choose from a...
  12. Jyggalag

    IndexMatch function not working, please help :)

    Hello everybody, I currently have something similar to this: Linking to this: It should return the date 21-06-2019 for XG10, but it does not. Can anybody see what I did wrong and how to fix it? Would be greatly appreciated! :) Thank you! Best regards, Jyggalag
  13. M

    Combo Chart - linking data to different data points

    I have attempted to attach the mini sheet below with a Data Input table in which I have created. All of the cells in the Standard columns have a drop down list connected to them including the following: Year 1, Year 2, Year 3 etc. The cells in the ticks column is a manual entry...
  14. M

    VBA needed to Update/ Change many linked excel charts in PowerPoint 2019 presentation. Change the entire path name including the Drive Letter

    I’ve seen a lot of examples of doing this, none that worked. I have a PPT presentation with over 200 linked charts to an excel file on my computer. Current FULL Path: "C:\Users\”myname”\Documents\1-MyDocuments\1-Annetta\OT\SURVEYS\2019 Survey #2 SYMPTOMS & DIAGNOSES\NEW FILTERED CHARTS AND DATA...
  15. A

    Is Excel better with images or links?

    Hi everyone, I'm designing a VBA Excel form that allows users to import images, and the part of of the information that included the image will be saved into another sheet for a different user to view. Should I try to insert the image itself into the sheet or should I put in a link for user to...
  16. S

    How to Import or link CSV with more than 255 columns in ACCESS?

    Hello, I have a .csv with more than 255 columns (395 exactly), I only need 3 columns but I cannot manipulate the source file manually, that is, I cannot divide it in two. The columns are: 131, 208 and 282 I have tried to do it by wizard but Access won't let me do it because it has more than...
  17. S

    Cómo Importar o vincular CSV con más de 255 columnas en ACCESS ?

    Hola, tengo un .csv con más de 255 columnas (395 exactamente), únicamente necesito 3 columnas pero no puedo manipular el archivo de origen manualmente, es decir, no puedo dividirlo en dos. Las columnas son: 131, 208 y 282 He intentado hacerlo por el asistente pero Access no me permite hacerlo...
  18. YaroslavZ

    Hidden links, source of which you will not find?

    Thank you for taking a look. I have a pretty simple file now that was built on a basis of an old complex file with a lot of links. In this testing file, Alpha (link) there is only 1 value, which refers via formula to 1 value of another workbook. The second workbook (Beta) (link) is completely...
  19. I

    Entering data into a cell has duplicated it in random cells in the same column

    Hi, I'm working on a large spreadsheet for work (not built by me) and I've encountered an issue that I can't quite get my head around. One of the columns in the sheet is Occupation and another Address, some of which had previously been filled out and some of which were still blank. After...
  20. J

    Add a link in the body of an Outlook task created from Excel VBA

    I currently have a worksheet that creates Outlook tasks based on line data from a table. Works like a charm however i need to create a link in the body of the task. I can get the file extension in the body but i would like to hyperlink it. I have done some research but have become confused...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back