basically

I've seen a similar question to the append with the heading of "Using a variable in a formula", but I can't fine the correct syntax for my particular problem which is as follows: =DATE(YEAR(summary_start_date)+1,MONTH(summary_start_date),DAY(summary_start_date)) I want to change the + part...

Hi, I have a VBA program that has multiple modules and basically it starts a userform on workbook_open event. Then it goes to a log on screen in the userform. Once a userlogs in the code checks credentials against database to make sure its legit then it goes through a subroutine which basically...

Okay, so question i have is this, i have a budget sheet that has the monthly bills in their own cell and my net on top and the leftover on the bottom. so basically the leftover formula is the sum of the positive currency minus the bills. so what i am trying to do is once the payment is...

Good Afternoon, I know this isn't an Excel question, but I was hoping someone on this board could help. I need to create mutiple routes on a map and was wondering if anyone new of a free service to do this task. Basically ill have 41 distinct across the US and the software my company uses you...

Hello! I'm trying to find what possible combination of numbers is causing a variance. I saw someone do a formula once to find this but I don't have that formula. We have a statement with close to 500 lines and I wanted to be able to find which combination of those number would make $$$ amount...

all having some issues with average ifs logic. my formula of "average if" / "percentile" works fine {=AVERAGE(IF('Data sample'!$E$11:$E$211>PERCENTILE('Data sample'!$E$11:$E$211,0.9),'Data sample'!$E$11:$E$211))} HOWEVER, when i try to add "averageifs", i cant seem to make it work...

I am a hopeless Excel User and need help with sorting Columns H,P,X,AF and AN. Each Row the data begins on Row 9 and goes to Row 26 Only. Basically, if i change the Dropdown to say "Yes" I want that Data to sort at the top of the list. Sorry if this makes no sense :)

I found the following thread: https://www.mrexcel.com/forum/excel-questions/995780-sumif-visible-cells-only.html which is great and I love it, but I need to basically do a SUMIFS on visible cells. so How would I put that together? Thanks,

Hello everyone, I have a quick question, how can I add a date range to the fllowing formula? =SUM(IF(FREQUENCY(IF('Master expense sheet '!C:C=Summary!D2,'Master expense sheet '!J:J),'Master expense sheet '!J:J)>0,1)) basically i just want it to do the same thing but just for anything less...

I'm fairly new to VBS, but have done lots of work in C, and C++. I'm having a hard time figuring out if what I want to do is even possible. Basically I have a lit of equipment that needs servicing each with a unique ID. The equipment can be broken down into two main categories. Each of these...

Hi, I have a query. I have a 2 tables of data, similar to below and basically I need to analyse how many pallets move in and out in a month, the raw data is inputted on the the bottom table but I want to know if there is a way to do a vlookup or IF function to basically add in the total number...

Hi, I'm not even sure how to title this and as such unable to find a solution which i'm sure is out there. Basically I'm looking to do a formula that says Basically i have 5 cells at as each gets filled out cell a1 would increase by 20 % so if A1 is "" then "" else 20% unless b1 is filled then...

hi guys, new to the forum.... im trying to code up in VBA but stuck at the moment hoping to find answers... basically i have this worksheet tab call "Fruits", with a column header starting at cell A4 call "Fruit Types", and subsequently A5, A6 onwards have different names of fruits. Basically I...

Hi. I've created an elapsed time (formatted as [h]) from this formula:-...

Good Morning, I've posted a photo so you can see what I'm doing but basically... I want to compare two columns and then subtract the numbers next to them if they match. I want to compare column K and column N, find the matches and then subtract column L from column O to paste into column Q...

Hi there! Sorry I'm not very good at Excel and have been struggling on this for a while - I've tried so many methods and tried hard to search for an answer.. Basically I'm creating a document to help me to do my job better and I am very limited to what I can do. The report I require the data...

I am so close with my macro... This is my last error. I am using the ActiveSheet.Range("").Select method, and it is doing the following: ActiveSheet.Range("A6").Select 'works like a charm for exactly what I need. I am copy/pasting between files, and using this works. I would like to use the...

Hi, I have what I think is a simple problem, but can't figure it out: Basically, some of my sheets may have a filtered selection included, some may not, but if the selection is not found the code seems to loop forever. How do I prevent this? Here is my code: Worksheets("Services...

Hi there, I'm baffled by a seemingly trivial problem in VBA, maybe I didn't define something? I was hoping ya'll can help shed light on this. :) Basically, this code works: Dim roster As Worksheet With ThisWorkbook Set roster = .Sheets.Add(After:=.Sheets(.Sheets.Count))...

Hi, Is there formula to split out contents of cell Basically say in a1 the value is 99999991 ..basically the formula needs to select first 7 figures from left then input a "-" and then have the remaining characters. So in B1 it would be 9999999-1 Other results would be 999999912 would be...