link

Have an odd problem when using excel in my computer. Everytime I try to update a cell in a spreadsheet that is already connected to another one, I being asked to find the file again and link it for every cell, this means that I need to go one by one selecting the file, rather than doing it...

I need query to scrape following website link data into excel spread sheet https://urlzs.com/11Wc9 There are 18,839 properties results appearing on above link. Fields I am looking to be exported into excel are price, location, telephone, square meters and the link of that property. 1st case...

Hi, I'm using index match reference, but I have to change every formula one by one, is there a faster way? https://ibb.co/X2pcKzP See the photo attached, I have to change the formula in G56 from '[7 July Shop Yields.xlsx]1.7' to '[7 July Shop Yields.xlsx]2.7'! manually but whereby F56 already...

So I am using filters to hide data from users. Depending on a login password. I un-filter or filter certain rows and then use filter refresh. However I guess anyone can link to tab on another sheet or file and then just copy up or down and see the filtered rows. Is there a way to stop this?

Debugger brings me to this line below in red. My file activityreportdatabase.xlsx is in the correct location and is not opened. I can manually update link with this file but it goes to the debugger when I do it with this script. The cursor in the debug window in on the line with...

I have code to open 1 of multiple folders, depending on the selection. Previously it worked like a charm. Now it hangs on MyFolder. I have no idea what is wrong. I have trouble shot it, & it hangs on the same location. Here is the code: Sub Partner_Resources()Dim MyValue Dim i As String...

Hi, I'm trying to ask VBA to prepare a new email in outlook using the following code: strbody = "<font size=""3"" face=""Calibri"">" & _ "Colleagues,<br><br>" & _ "New Request Saved in the following location: <br><B>" & _ ActiveWorkbook.Path & "</B>\<br>" & _ "Click on this link to open the...

Hi, I have used iqy files for excel on mac. It loaded the table results and i was able to format it but it left the hyperlink as needed. I decided to try power query and used my windows version of excel and I am able to make the connection and pull the data. Much easier to deal with. But the...

Hi guys, I'm a Software Engineer in Excel at work. I've a project where I have to paste links with other cell references (e.g. =TEST7!BG13). Sometimes when I run my code I get a "No link to paste" error. Any idea why? The data to process is always the same. Piece of the code...

Hi All, I have a Powerpoint presentation that pulls data from a worksheet from excel into it. I have tried the embedded option with update link ticked. I have managed to get the embedded object to auto update with no problems. The issue arises when I have another workbook open that is used...

I am unexperienced when it comes to navigating websites using VBA (or any code). I have been able create code to open the desired websites but now I am trying to automate "clicking a link" to save additional time. I have an excel file full of various patent numbers. I have been able to...

My company has a xls file on a onedrive folder. How can I link a worksheet to one of the worksheets in that workbook so it always is up to date? -Eds

Hi all, I am currently working on an order form for our warehouse. I have a master sheet (Template) which holds all the current items we stock. When entering the quantity to be ordered on the master sheet, it is transferred to the Order Form. Here is the code used for the transfer of data...

Hi I created a Treemapchart using excel 2016 I am trying to copy & paste the chart into a word document using the link data option however the option is not available. I want to link the chart to the word document so it automatically updates whenever I change the source data in excel. Thanks

I create a account Statement and Invoices Workbook File, First sheet is the account Statement, and after each sheet will be a new invoice. I want each time I add a new sheet as a new invoice, as Copy Paste, a specific data from a specific cells in that new invoice sheet will go automatically to...

I'm attempting to link worksheets using ='worksheetname'$A$1. I'm getting that reference in the cell I'm linking and not the actual value in the cell I'm attempting to link. Thoughts please.

Hi All, I've come up against an issue. I'm sure it possible, only I don't have the knowledge. I currently use Excel to keep track of what customers owe and when they pay. In it's basic form, it consists of two boxes for every day of the year. One records what they owe for any particular day...

Hello! I have looked up and tried every link and suggestions already on line that I could. Unfortunately, I'm still having trouble converting a CountIf function to SumProduct. I'm doing this because I need to link my CountIf to a closed worksheet. My original CountIf function...

Hello, I have a list of URL links in excel and each link goes to a breif WAV file recording. In fact, when you click on the link the option pops up to either open or download. Is there a way to through VBA, MACRO, or other automated means to run through this list of over 40,000 and download...

Hoping someone can provide some help on this. I have a spreadsheet where people fill out the sheet with their skill assessments. Once those are filled out, the responses using the IF function and vlookup would populate the Development plan tab. Some of the items that get pulled into the...