help

Hello, Sub Reset_Filters() ' ' Reset_Filters Macro ' Resets all filters ' ' ActiveSheet.ShowAllData End Sub If there are no filters applied, I am getting the below error message when the macro is run (it's assigned to a button): And when I debug Kind Regards

Sub COOutlookReminder() Dim OutApp As Object Dim OutMail As Object Dim strbody As String Dim myRequiredAttendee As Variant Dim Address As Variant Set OutApp = CreateObject("Outlook.Application") Set OutMail =...

Hi everyone! I have been asked to lead a presentation for my company. I have a shortened list of some of our sales staff and a longer list with all staff. Is there a way to transpose a list of quarterly performance from the shorter list onto the longer one whilst keep any gaps? I am fully a...

Hi, I am a teacher and I have been given a list of students who's grades I need to have a closer look at in excel. I have a curated list of students in one column and the raw listing of the students in the next column with the associated grades after that. I want to remove all the students from...

Hi Everyone, Struggling with three different scenarios; scenario one: if Column Row says "New" return "new", scenario two: if scenario one is true, but date is less than 2/1/2023 return "transfer", scenario three: if scenario one and two are true, if balance is greater than (>) past month...

Im stuck at getting a macro to filter through some data. I have this data set; This continues for 1000s of rows, i need a macro to: Go through date/time col check for any overlaps where there are overlaps compare to ocular hazard col if both dates have ocular hazard 1 then only paste one of...

I'm trying to create a visualisation that goes back 12 months from the selected date in a slicer. Using this video - I have this code: TRI P12M = VAR ReferenceDate = MAX ( 'Date'[Date] ) VAR PreviousDates = DATESINPERIOD ( 'Previous Date'[Date], ReferenceDate...

Hello, I have a running monthly total of sales. I type the value in Column L. I have a formula which finds and returns the most recent entry. That formula is LOOKUP(2,1/(L2:L13<>””),L2:L13). In column K is the corresponding month, Jan-Dec. What I would like is for excel to find the most...

So I have PowerQuery cleaning some data and splitting it into different work groups. Works a treat, saves me mucho time and effort. But I am now getting greedy and want to push it further. Can I get PQ to: Split this into different workbooks instead of worksheets. That is rather than, say, 10...

Hi all, Relatively new to formulas in Excel and trying to figure out how to match 2 values and then check their corresponding price in the next column. In the example table below: - Col A contains Unique ID 1, while Col B contains the corresponding price for Unique ID 1 - Col C contains...

I've got some VBA code in a macro to auto-create a workbook and create a Pivot table (below). The whole thing works like a dream, and throws no errors, creates everything but I can't get it to add the row field to the pivot table. I found the script a while ago and saved it for later use, but...

I often find myself sifting through large amounts of data to identify relevant keywords, and as many of you may know, this can be a time-consuming and sometimes frustrating process, particularly when it comes to spelling errors. To address this issue, I came up with the idea of using PowerBI to...

Good Afternoon, I am trying my best to create a golf spreadsheet for a league. I am curious if anyone has a current golf league spreadsheet that contains any of these. I would love the quota spreadsheet, but would take any. I am struggling on excel creating formulas although I have had a great...

Good Afternoon, I am in dire need of help. I am not to savvy with Excel. I have been struggling and seem to find no answers on how to convert someones score to par, to points in the row below. For example in quota point system, its a lot like Stableford, but ones handicap is subtracted from 36...

Hello, So I have summed values based on week in this configuration 202301, 202302, 202303, 202304...... it is in a row. Below I have summed values based on this headers from pretty big data sheet I used sum product. My question is, I would like to have a formula which will work like that : I...

Building an excel formula that if a store is required to be open til 1am and their sales from midnight to 1am is greater than 100 then "yes" if not true then "no"

I have been getting a type mismatch error with the following code. I believe it is happening within the 'if' statement. Sub Hold() Dim c As Range Set c = Range("C2000:C2050") Dim r1 As Long Dim r2 As Long Dim x As Long Dim i As Long For x = 2 To c.Cells.Count...

I have created an excel spreadsheet showing a list of inventory. I wanted to be able to put an X in the final column to provide an easy move to the out page. This will let me know when thing are taken out of the warehouse. I have created both worksheets. I even got the code and them up and...

Hello =IF(OR(ISBLANK(B3)), "", SUM(B3)*NETWORKDAYS("01/01/2023", "31/12/2023", 'Lists (Hide)'!$D$2:$D$26)/2) If I enter non-numerical value in column "B" where the above formula sums from, it returns "0". I was planning to use IFERROR with the above formula to return a message if a...

=INDEX(Table!$B$3:$E$450,MATCH(A2&"Schedule 3"&"PLACE 1",Table!$E$3:$E$450&Table!$C$3:$C$450&Table!$F$2:$F$450,0),1)