link between worksheets

Dear Excel wizards 🧙‍♂️ I hope that you can help me. I want to create an family overview from different individual worksheets. On these worksheets, I have a combination of single dropdowns and multi-select dropdowns as can be seen below. However, when I link fields from the overview sheet to...

I really hope that the thread title adequately describes the issue I currently have... @John_w has kindly given me a very good solution for deselecting from a multi-select dropdown, which was an issue that had me puzzled for a long time. I now have a workbook with 3 worksheet (sheet 1, sheet...

I don't actually know how to word this question. I'm not looking to simply link cells together with an = or similar function. Is there a way to set up cells so that if I change the value in any of those cells, they all change? Ideally, they will link across sheets. Example: A1, B2, and C3 are...

Hi all, Currently looking to create athlete programmes and am looking to allow the athletes to select their name from a dropdown box. By clicking on their name, this then will take them to their individual tab/sheet to edit and input data from training sessions. This, theoretically, will save...

I asked this a few weeks back and did not get any hints. Trying again I have a worksheet with header block currently sized a1:eJ and rows with data (Header is likely to widen over time). I have two separate types of worksheets I'd like to create with this: First, individual sheets for each...

Hi, Does anybody know of a workaround or have previously tried this: To reference a value from one table in one sheet to another table of a different sheet using a unique ID common to both, however the unique ID is not in the left most column of the table array. Thanks. Cailean.

Each week I receive various weekly reports on separate spread sheets which I save in to different folders and Id the report with name and Week number. I wan to take specific information from each report and put on a summary report showing changing data by week as we go through the year. I set...

I have multiple workbook (around 60), which I have to copy & save in different folder as month change but workbooks name remain same. So, for Jan month path will be:- C:\2016\Jan\WB1.xls, in Feb it will be:- C:\2016\Feb\WB1.xls and so on..... Data also changes each month. There is tab named...

Hi all I have a bit of a wierd problem I have saved a spreadsheet on our server as a shared workbook that gets populated from a userform on my(or the other users desktop) The macro opens the workbook on the server, copys in the info from the userform into the "Master Data File", saves the...

I have three separate pivot tables from the same data source (existing connection) all on different worksheets. Is there a way to link the Report Filters so that whatever changes I make to the filters on the first pivot table automatically update the 2nd and 3rd pivots? So for example is it...

I have a VBA macro written (it's at work so I don't have it here) that creates a hyperlink based on a cell value. It is used to call up data related to the cell value. The displayed text is the cell value. It works fine. Next I create a pivot table that includes the column that this data resides...

I have a workbook with 7 sheets containing part number of a product in column and its cost in adjacent column. And the 7th sheet contains total number of parts in all the sheets. I want to change cost of some products but then I have to do the same in all sheets. Is there a way by which it...

Hi all, I have created a workbook which consisted of one worksheet in total. You could say it was similar to a summary page, but without really summarizing anything as all of the information was collected in that one sheet. I now wish to change the formatting of the document as I need to input...

i make a template with formulations in main sheet and add other sheets by client`s names , i want code to transfer template from main sheet to client`s sheets by client`s name in template at "E3" coontinuously when i fill data in template in main sheet and press commandbutton.

Hi, I have a workbook with multiple worksheets and I am struggling to link some of the data so I can review different bits of data on a single sheet. I have run 6 reports and used pivot tables to combine the data into a single worksheet named project summary to evaluate project to project...

Hello Experts, I am having trouble to find the details as mentioned below: Suppose this sheet as a Master sheet (sheet 1). & I have 4 other sheets i.e. AAA, BBB, CCC, DDD as per name of Company. A B C D E F <tbody> SN...

Hi, I think I need vba for this... In one spreadsheet I have conditionally formatted cells with a formula to highlight the name of a staff member as well as their start year based on the year. For example: 2013 = yellow, 2014 = grey, 2015 = green. This works like a charm with the...

I am having a linking issue where I get an error message that "links were not updated because file was not recalculated". I do have access to the source, and it will open fine. However, I continue to get this message. It is causing a real problem because I have many links and it gives an...

I am getting an error when the scheduled autosave feature that also updates links in my workbook finds the source workbooks open. It runs with no problem when the source WBs are closed. Sub SaveBook() With ThisWorkbook .Sheets("Receiving").Select .UpdateLink...

Long time reader, first time poster here. I'm working with a lot of files where the process could be sped up by simply importing the information, rather than typing it in by hand. Most of my source files consist of tables. Ex, an .xls with 15k rows/8 columns, a few .xsld around 20 rows/20...