link cell

Hi, At the top of my spreadsheet I am going to have the Clients name. The client name information is taken from a sheet in the workbook which hasn't yet been created. For example, in Sheet1 Cell D6 will have the following formula: "=ABC!B3" which will bring through the clients name. However...

Hello All, I have a workbook that references other workbooks to create a master sheet, not using SQL or query builder, simply "='[workbook.xlsx]Tabname'!A1" etc. Within the workbook i have linked cells that open the work that its referencing when double clicked (standard hyperlink). Does...

I inherited a bunch of workbooks that have many links, but cannot change it, so dealing with it. Is there a way you can put parts of the link in a different cells and then combine them to create the path, workbook, tab, and cell, you need for the link? I can get it as text but cannot convert it...

Hi I have a problem I'm trying to solve for quite some time. solving it will help me a lot, saving much time. I'll try to describe it to a simple use case and if there a solution is found i'll be able to use the principle for the more complex need. Here it goes, I have a table with two...

Hello all I am having difficulty creating an autofill formula. The first tab of my file is called "By Room" and I would like to link exactly every 9th cell down the sheet (starting with B7 and going forward, B16, B25, B34, B43 etc.) to the second tab, called "Ceilings" into every cell without...

Hello, I can't figure out the following: I have a list of names as part of a table in Column D: Ex: Adam, Bob, Cindy, Dave. When I filter out two names, how can I get the name in Cell A1 that is on a different worksheet to show the name that appears the most. For instance, if my filter in...

Greetings, I'm trying to create a dynamic chart title by inserting a text box in the chart title that displays the value of the last populated cell in column A. The number of rows increases over time, so I'm trying to come up with a dynamic cell reference. When I hover over the text box a tool...

Hi, I have a set of Form Control check boxes on my Excel sheet which I have assigned to macros. However, for each row, I had had to create individual macros per row. Instead, I would like to just have the two macros below and use the format control cell link row number to set the checkRow...

Ok, so this is something which is probably so simple but I can't figure it out. I need a macro to create a linked cell to another workbook. The name of the workbook will change every time. The other workbook gets assigned a name based on a value they type into a form at the beginning, which is...

Hello, Thanks for all who will help me out from this situation. Scenario I have a "cost.csv" file that contains the cost of the toys. The cost is show in $ with two decimal places i.e. $0.75 I created a new MS Excel 2010 workbook file named as "customers.xlsx" that has four columns i.e. Item...