excel 2016

MS Excel 2016 This is the first time I've used a query, so I could very well have constructed the applied steps incorrectly. My problem is that records from newer files are not present. The query is designed to compile lists of reviewed records from weekly reports. They are the same lists...

Hi there, I'm working with a data sheet and am trying to get the Nth largest value in a specific column based on multiple criteria. My single criteria formula works fine, this is it: ={LARGE(IF('Sheet1'!C:C=3,ABS('Sheet1'!W:W),""),1)} However, I run into the #VALUE! error once I add another...

Hello All, I have a small script that takes values from one sheet and populates other tabs based on specific criteria. I have a small declaration of variables that I am trying to validate that there are values within the variables, if not I want to change the variables to "N/A" as the...

Hi guys, I want the below result from the string, how can I do this with formula? AB1STRINGREQUIRED RESULT2BBBA123A3BB1234B4CC3C5DD123CD6F11CCD32CD7F11CCE32CME8F11CCF3CMF9F11CCG345CG

Hi, Newbie here with very basic knowledge on how to use VBA (not knowledgeable enough to create VBA code). I need some help in creating a list of all peers for a given employee list. Below is a sample: Employee List Emp Name Manager Name A1 M1 A2 M1 A3 M1 A4 M2 A5 M2 Output...

Excel 2016 Windows 10 I'm trying to loop through all my controls on a user form to ensure they've been completed; I'm confused on how to check to see if one option button has been selected in a group of buttons. Each button is coupled with only one other button per group name, so if either one...

Hello Gurus, Hope you are doing well despite the pandemic. I was wondering if you have any idea on how to code this: 1. I have a worksheet with 5 tabs or more (may vary). The headers are same (see below): Number Name Sales Div Data Note 1 Sam SA 100 2 Amy FA 90 2. I want to create...

I'm trying to access FTP using hostname, username & password. need to access the particular folders and copy the latest file (Based on created, as the filename may vary each time) to my local path. Copying the latest file is working using the below code. Could someone probably help me to append...

I am using Excel 2016. I am attempting to loop through a set of controls within a frame in a specific order and writing their content to a worksheet. I've tried defining the tab indexes, which seems to do what I need it to, for the most part, but a few controls are not looping in the correct...

Hi everyone, I developed a file on O365 using Power Query for my wife to automatize some tasks. On her laptop the file with power query would not work (using Excel 2016). I first thought it was linked to a version issue but then I did the following on her professional laptop : Close and...

I'll try to be as brief as possible. Here's the rundown. Setup: I have 2 Workbooks. I'm trying to loop through Workbook#1 and for every cell that contains a blue border, I then want to search for that cell value on Workbook 2 (a result SHOULD always be present). Once the result is found, I...

Hello all, I'm trying to create an array loop that goes through columns A1,D1,G1, J1 (Keeping the headers) from one workbook and paste all the data to one column (keeping cell formatting) on another workbook. The data in the copied columns (A,D,G,J) will vary every time the macro runs so I'm...

Hi there, I've been pulling my hair out on this one, I've got a large range about 1249 rows with 68 columns, due to privacy agreements I cant release any screenshots of the actual spreadsheet. So I have included an example below. So I need to count the conformity within the 'lemons'...

Hello all, I am having some issues with a statement in my current code and all sources online aren't really answering my question directly. I have a fairly long script that loops thru a range to get a filter criteria value and then apply the filter to a range on a seperate sheet. This code...

Hi everyone! I am stuck on a task that I am not sure how to accomplish but it is pretty straightforward. My workbook has several sheets that I can put into an array that I want to extract only the first row of data E4:V4 and paste these values into Sheets("Daily Log") starting in the same range...

Hi all, I have a two columns of text which I need to make sure both match as the data comes from different sources. Both columns of text have characters in the text that can throw off the match formula as being an error, example below: The name match says no to one of them because there is a -...

Hi, I'm trying to import some data from the web using data connections and I keep getting this error: "Unable to connect. We encountered an error while trying to connect. Details: "External table is not in the expected format."" The link I'm trying to connect with is...

Hi everyone :), Is it possible to save my workbook on to the organizations network so that anyone may access it for viewing purposes only? But i want to be the only one who can go in and make changes. All help is greatly appreciated, I am going into excel right now with very little to no...

Hi All, Hoping this is a quick one. I have a data sheet (Master) that contains a report of all the products in our inventory, I have a second sheet (dashboard) with a quick snapshots of Promotion Start/Lock dates. Not sure the best way to get the data into the sheet. It could be from a...

Hello everybody, I am currently managing a worksheet containing a stock overview, which looks like this: I have made two conditional formatting rules which assert under my "Antal" (meaning Quantity) column that if the number is below or equal to 0 the color should be red and if the color is...