excel 2013

Hi, Here is an example with my challenge click (onedrive files) I following cues from https://powerpivotpro.com/2011/09/creating-accurate-percentile-measures-in-dax-%E2%80%93-part-i/ and ERRATA https://powerpivotpro.com/2012/05/percentile-measures-in-dax-errata/ I am trying to get...

For the last several yrs I have queried a URL and downloaded that table to a worksheet then used the data to populate another sheet. The query no longer loads the table data, only general info from the page. here is the URL...

Hey All, First time poster, as I am having a real crap time getting this code to work... I found a segment on one of these forums and need to amend it slightly... I need to detail the row that is copied and subsequently pasted. I have tried every form of syntax I know how. Even paid...

Hello Experts! I am having a problem when it comes to ranges and message boxes. To give you a picture, if excel finds a "False" text in col B, then it will display the message in col C. If there are many noted "False", then it will display all the messages in col C. Example A...

Hello. I am trying to use a macro and VBA to consolidate files by copying the first worksheets from multiple workbooks and pasting them into one worksheet. I Googled and found the code (below) and modified it to meet my needs. My code works successfully with smaller files. It automatically...

Hi Once again consulting the genius that is the MrExcel Community I am trying to find a way to create a unique sequential record number when my userform inserts a record in to a table. To be added when i run the below the code. Have just left column 1 of the table with the easy =Row() which...

Hi, I am using Excel 2013 and I am experiencing a problem trying to create a number of Hyperlinks from two Worksheets to a third within the same Workbook. In the Workbook there are three sheets. The first Worksheet is pretty constant whilst the other two change on a weekly basis. Worksheet 2...

Hello all, I am trying to figure out a way of highlighting columns that don't contain any data in excel. As a example below, how would I be able to highlight the fact the Job column so it shows this column has no data. Tried with a Pivot and conditional formatting but no luck :( On a small...

Looking for some recommendations of online Excel courses to advance myself a bit. If it is advanced Excel dealing with pivots, dashboards, power queries, etc. That would be great! Also looking at introduction to VBA up to Advanced VBA. All VBA knowledge I have, I have pieced together. I would...

I am currently working on an excel project for school and I am unable to figure out how to align the form control buttons to the left and then vertically distribute it. I have tried adding the options to the quick ribbon but they are grayed out...

My url's are of the following format: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans...

I am trying to create a simple relative cell reference to a cell in another workbook which copies the content from that cell to my current worksheet. When I do, it creates an absolute cell reference, which works for that particular cell. But if I copy the formula down to the next cell, it is...

The problem is the following, i want to create a Table in column L as seen in the image, but i want to exclude the ones that the formula returns blank. I want the table to automatically count only the ones which return some value like "Test1", "Test2", etc., and exclude the ones that return ""...

Dear All, I'm using excel 2013 @ my workplace, and colleague asked me a question regarding VLOOKUP approximate match. Now the way I learned it from Mike Girvin is that it looks through the list and finds the 1st value that is larger, jumps back 1 row and delivers wichever col_index_no you've...

My VBA just ran through and created 2 20meg Excel files and I've called the routine to send them to SharePoint. ' =========== SEND to SharePoint ============================ L = MsgBox("Do you want to send the finished files on SharePoint", vbYesNo, "SharePoint") If L = 6 Then...

In Excel 2013 the user can save a web query as a file. But there's no option there to open an already saved query file. This article describes how to edit the resulting .iqy file to make it dynamic (but to open the .iqy file it says "go to Data>>Import External Data>>Import Data", which does...

Hello Everyone, This is my first time posting here. I have found myself at MrExcel a few times when I was working on ideas to expedite my workload by having Excel do as much of the work as possible. I would also like to point out that I am a little failure with Visual Basics and I’m always...

I've been working with ERP data in the past few months. Lately, Excel seems to be hanging with the processor usage in the bottom right corner slowly increasing. There are also intermittent white screens and (Not Responding) messages. Sometimes it recovers, sometimes it doesn't and I have to...

Hi, I am trying to create a macro to create a graph on some data from the spreadsheet. To do this I have recorded the macro of the graph I am trying to create being raised manually. The table I am trying to show data from is quite obscure and I am having to edit the graph plotting points...

Hello Experts, I have the dates columns in the sheet name "Dates" where the format of the dates are wrong. I filter the wrong dates to sheet name "Raw Dates" where I have placed formulas that corrects the date format in (col I) and when I'm trying to paste the dates back to same column I am...