linking

I need to have Excel display images based on the file paths from another column. In a certain way: column G shows the name of the folder column H shows the name of the file(usually: 00, 01, 02, ...) column I specifies the filetype ONLY if it is different from .jpg The image should appear in...

OK this is a three part tricky problem. After reading some useful online information about linking Excel 2016 workbooks I decided to try it in an effort to ensure data consistency and reduce the amount of time it took to update nearly 100 workbooks with relevant foreign exchange rates data...

After ive have been linking over 100 cells between 2 different excel files, all of a sudden, my links all went #REF! and I have to start over :( =VLOOKUP(D459;'[1. Speedo Cases GEM 170728.xlsx]speedo'!$B$10:$FZ$115;3;FALSE) became =VLOOKUP(D483;#REF!;3;FALSE) Any one has an idea how this...

I'm using the following formula: =HYPERLINK('STW Lin Acc Upgrade'!F16,[Project Number:]) Whenever I click the cell, I get a pop-up error message reading "can't open the specified file." The thing is, I'm not linking to another file. I'm just linking to a cell in another worksheet in the same...

I want to copy value from one worksheet to another sheet within same workbook for two column. I want the first or second column to be searchable means dropdown with dynamic suggestion as am typing based upon the value another column must be filled. Clear understanding purpose: For example...

Hello, I am trying to link a large number of combo boxes to their corresponding cell. The Combo Boxes are in cells K2:K300, and I need a quick way to link them all to their current cell. I know how to do it manually, but manually linking 299 cells would take all day. :/ Any help would be...

Good afternoon - I have a tab (Tab 1) that I use to track headings for annual financial statements and another tab(Tab 2) that tracks headings for interim financial statements. I want to be able to have Tab 2 always match what has been changed in Tab 2. So for example of I want what has been...

hi all I have put 3 pivot tables on one report which are created from a query with criteria to input to and from dates which work however when I run the report it asks me to enter the dates about 15 times. my questions is this... is there away I can link the criteria question so the I can just...

Hi there, I currently have two excel workbooks. The first includes data on a worksheet. The second workbook I want it to update and log the data from the first workbook: So for example, I have a command button in the 2nd workbook and when pressed it searches for newly updated data from today...

I have many different distributors and sources where I get product for my business. I'd like a section on my excel page to summarize how much profit each source is providing. My current sheet already tracks sources and profit for each individual item, but I'd like it to add up everything and...

I have a very large file that takes a long time to open for one reason, every time it attempts to open, the bottom toolbar (that displays progress in opening the file) shows "Linking:...". That file is not in any way relevant to the file I am attempting to open. For example, if I have a file...

I've Sheet 1 with my data that I am filtering to update results. On Sheet 2 I'm using a COUNTIF formula to update the results based on the filtered Sheet 1 results. =SUBTOTAL(COUNTIF(Sheet1!1,D:D) What i want from this formula is the total number of '1' in Column D of Sheet 1, based on the...

Hi there, A theoritical question as I don't actually have the worksheets yet but is it possible to link a cell up to multiple cells on different workbooks if the workbooks don't exist yet? Ie - I want to have a master spreadsheet that tracks the hours people work from their timesheets but they...

Hello, I am trying to collaborate on an Excel workbook with other colleagues. We are all using Excel 2010 and saving the file to the same network drive. We have embedded links to a path on the network that we are all able to access. When we open the file, we are prompted to 'update or not...

Hey guys. I have two workbooks, one where new data (new_data.xlsx) is stored and one where old data (old_data.xlsx) is stored. I need these combined into a new workbook (data.xlsx). Data will continue to be added into new_data and old_data so the data.xlsx needs to continuously pull from both...

Is it possible to link the name of a worksheet to the name of cell without using VBA? Or even with VBA? For easier navigation in large workbooks, I would like to name cell A1 whatever the name of the worksheet is. Thanks!

I have 12 excel files that contain a column with dates. The dates occur multiple times. I need to count the number of occurances of each date on all 12 files. Is there a way to do this with a formula or array? Example, <tbody> Date column on file 1 6-1-2015 6-1-2015 6-3-2015...

I am curious to know if one could create a "management overview" workbook containing live links to various other workbooks. As such, the values on the single management workbook would change immediately after values were changed in any linked supporting workbooks. The tricky part would be that...

I'm curious if it would be possible to send a query string to an Excel file, similar in the way you would to a server-side webpage in the URL? For example, a link in a Word document: \\path\to\file\my_workbook.xlsm?id=123 Click (or CTRL+CLICK) opens file in Excel, Workbook_Open() is called...

Hello, Is it possible to link several sheets by just using a drop down? (even VBA) Thanks in advance! :) Example: Instead of using a normal hyperlink I'm just gonna use a drop down where after I choose it would automatically redirect me to that sheet?