things

Having a brain cramp.... In Cell A3, I have a formula that is based on A1 and A2 Cell A4 should display 0 if A3 is greater than 0, but should show the absolute value of (A3 x5) IF A3 is negative Tried a few things, but I am stuck.....much thanks in advance for the help. In the meantime, i...

Hi All, New to VB & even newer to using power query, I have set up a connection to a sql data base and carryout a rough quick filer of most of the junk I do not require. This is shown in a tab ("data") for example I wish then to filter further down this list by looking for keywords then this...

HI IVE USED THIS THAT SOMEBODY BUILT FOR ME FOR A WHILE... I CHANGED A FEW THINGS TODAY NOW WHEN I TRY AND SEND IT GET THIS ERROR

Hi What is the difference between them? Not sure why we have 2. I noticed there are many things like that SortField SortFields and OpenFile vs OpenFiles. Thank you.

I have an array with a sumif and looking to add a sum if not greater than for a date column. The data can be a date less than or anything else like text. Is it possible? I've tried things like <> > but that doesn't help.

Morning All, I'm not sure if this is possible but was hoping you could tell me. I need to write a macro that does lots of lookups and others things by comparing two spreadsheets. The spreadsheet that is being used as the lookup will have a different file name each time it is run. It is...

I can not remember the "name" of this feature to look it up in the book. I've got a bunch of gas receipts that I'm auditing and I want to highlight purchases on weekends and outside of work hours. What formula can i use to quickly highlight these kinds of purchases? I'm having a hard time...

I have tried several times to use the method that all the help websites have given on how to copy and paste a bunch of non-sequential cells in a filtered list and it is not working. I have tried selecting the cells I want to copy, then clicking on the "Find and Select"--"Go To Special"--"Visible...

<tbody> </tbody> please can someone help with these 2 things i need a formula to exctract the number this one Delivery Area: 01 - Glasgow / Edinburgh i need the "01" and this one Company Code: 99 & 499 Delivery Yr/Wk: 2018 / 12 Product Category: ALL CATEGORIES i need the "12"...

Hello, I was wondering if it was possible to create a checklist next to a PowerPoint slide; not a checklist slide. For instance, a slide will have a header, some text and a picture. I was curious to know if I can have a pop-up form or something in the slide with a checklist for us to ensure...

Hi Guys, First of all this is great forum, before opening this thread i already searched around and found some formulas that has helped me tremendously. I will be opening few more threads one after another to make things easy on my tiny brain. as of now I want to do the following: I have List...

So I'm having an issue getting my formula to work properly. What I'm trying to do: Highlight the cells that are greater than 67% with criteria of engineer, delivery, M/S or other. These are in two separate columns. If I use this...

After Selection.Find.. the whole column in question remains selected/highlit. I don't really want to leave it like that but so far these suggestions don't seem to work in my version 2007 SendKeys"{ESC}" Application.CutCopyMode = False Any other things I could try (apart from selecting...

Hello All! I have a massive workbook with thousands of records. For each record, I need to include three weighted averages. I am using SUMPRODUCT to calculate the weighted average. Every time a change is made to the workbook, it takes about a minute to calculate, which gets old very quickly. Is...

Hello, Can anyone please tell me what is wrong with this line of code. The aim is to determine if the field called Search_TB on a UserForm is blank or if whatever value is in that field is not in column 1 of a worksheet called ManSheet. If Search_TB = "" Or...

Hello all! I'm looking to pull out a code from the middle of a text string. The codes are always 22 characters long and come after the phrase "Code:" Example in cell C4: Welcome! Get $X off $X purchase. Code:xxxxxxxxxxxxxxxxxxxxxxxxxx EXP {{date:MM/dd|+30d}} Excl Apply.Approx 5 auto...

I cannot figure out how to write an IF statement. IF 9,000 or less = 0, IF 9001 - 11999 = 3, IF 12000 - 14,999 = 4, IF 15000 or greater = 5 Please help I've been trying different things for almost 2 hours and I'm confusing myself now!

Hi everyone and thank you for reading my post. I am trying to save tonnes of time and simplify a process of tracking learners by listing everyone in one Sheet but then have their details automatically populate a second sheet based on the value of one cell (in this case the course code), then if...

Hi Everyone I have this macro to filter dates but I need to be able to combine the two so it does both things So basicly it currently chages the filter to just "Sheets("PropPDD").Range("$A$2:$J$10000").AutoFilter Field:=1, Criteria1:="<=" & EndM" I need it to do both? StartM =...

In my life I have struggled with assumptions. They are an evil necessary. When I was younger, I questioned everything and refused to be nailed down on any idea; to the point of not being able to get things done. Some scientists rely on this heavily. As I grew older I found that I needed to...