link

Hello, I have a feeling the answer may be no, but I'm looking to create a table - linked between Excel and Word - where part of the table is Excel data -> Word, and the other part is Word -> Excel. I would like my staff to enter comments against each student, but have been told by many that...

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

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...

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...

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

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...

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...

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...

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)...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...