linked

I need you to help me complete a macro, I want to pass a data from the macro to the linked page and then bring the information back to the macro.

Hi All, I would appreciate some help with the following problem: I have a workbook (using Excel2013) with ca. 20 named worksheets of which I would like to delete approx. 10. Having earmarked these 10 sheets for deletion, I just want to check if the Worksheets which will not be deleted, are...

Is there a way for Excel to search linked files without having to have the filing to be searched open? i.e.; File A searches linked File B but unless user has File B open at the same time you will get #VALUE ! errors.

Hi all, I have a linked table that is used by an update query to update records in the main table of my database. Everything has been running smoothly ... Normally, there are between 100 - 500 records that are updated at one time, on a daily basis, by this query. They join on a UID that is...

I have two tables, [ActualSales] and [ActualPayment]. They are both have 3 columns, [ActualSales] contains: "Date", "InvoiceNo", "SalesAmount" [ActualPayment] contains: "Date", InvoiceNo", PaymentAmount" I tried building a linked Date table and a linked Invoice table and hoping to connect and...

Can worksheets be protected to view only that have VBA code assigned to them that are linked to other worksheets? I have one work sheet that is for data entry and another work sheet link that I want to be viewed only. The view only worksheet has cell's linked to the first with charts...

Dears, I have a big range of data of spare parts where I need to find the right part and press hyperlink to view the picture of the part, is it possible to sort the pictures which linked to a certain Manufacturer or other certain cell related to the part, so if I filtered the excel sheet I can...

Hi, I am looking to use excel (preferably a button) to kick off a macro in access which in turn will then update tables in excel that are already linked to this dB. I have not found a good solution to this so far. Any help is appreciated. The macro in Access will populate certain tables in...

Hello there! I have several forecast models linked to various source files (i.e. sales volumes) and some linked to each other (i.e. staffing model pulls actual from finance model and finance model pulls forecast from staffing model). If I open two files at the same time from Windows Explorer...

Hi all, Kinda fumbling my way through learning VBA/Excel. I'm going through different tutorials online and can't figure out how to do the following. Any help/tutorial links for this would be appreciated. I have a spreadsheet with financial data under a given month. I need to put a button in...

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

Hello All! I am using office 365 and when i insert a column into a data sheet, all the reports that I have linked get miss aligned. Is there a way to insert a column in the middle of an existing worksheet without having to go and update all the linked data reports? Any help is greatly appreciated!

I would like to know how to automatically change the fill color on a linked sheet when fill color is changed or a new cell in set using a fill color on the source sheet (sheet1) Your assistance in this regard is most appreciated

on sheet1, I have all my data. I have several sheets where I have linked the data for each branch, using Paste Special Paste Link All when copying the data However, I if change a comment or fill color on sheet1, this does not change on the linked sheet. your assistance in this regard is...

Hi, my first message I have likert scales (1-5) that I created with Vba. There are groupbox in every row and include likert-scale(5 option buttons) in columns. The number is quite over 100. When you select each options, this options values writes the linked cell. I want to ask...

I have 2 linked tables and wish to create a pivot table showing employee ID, Name and the person's related Role. The tables are linked on Employee ID but query displays what's shown below: Emp ID Name 123 John 456 Bill 789 Joe Empl ID Role 123 Admin 456...

File 2 has a linked cell pulling data from File 1. When File 2 is opened, Data in linked cell is updated, clearly changing File 2, but I do not get prompted to save file 2 when I close it. It just closes without saving. If I edit/add anything to File 2 manually, I do get the prompt to save...

I have an issue with a linked excel file. My data comes in as short Text cutting off the data and I cannot get Access to change the field I need changed to Long Text. I do not see an option to change it to Long Text when I import it either. Any idea how I can resolve this issue?

Generally, the question is: Can the Linked Cell property of an ActiveX control be dynamically changed? Specifically, what I am trying to do relates to this: I have 2 Worksheets, the first, Sheet1, with a table A3:D1000 where Col 2 is filled with a bunch of different "First Names" but some...

Hi all, New here and noobie to Excel. I'm in the process of creating a PNL chart for personal uses but came up to a problem that Excel kept showing weekend dates on my chart. I've searched around and people say to change the X-Axis type to "Text" but that don't help much because the cells I'm...