excel365

Hi, I've created a formula that works fine if it is within the sheet where the data originates, if is filtering the routes our vans will be taking and excludes any blank routes (if a van is not scheduled out that day). But I want to have the summary in another sheet dynamically changing based on...

I have a workbook with scripts/modules. And running through many of them with the logic of: For Each sh In Worksheets If sh.Name <> ..... etc ActiveSheet.PageSetup.CenterFooter = "& "&N" or whatever i need on each sheet. I am excluding Sheet1 from the 'loop'. But on Sheet1 i have a image...

Hello, I would be really grateful if someone could answer the following If the TOTAL of two cells is less then the value you of another cell then post cells red, for example; if A3+A4 is less than C5 turn cells red thank you in advance

I have a 2D table of timeseries data. I am able to use the following equation in column B: "=BYROW(Value_Array,LAMBDA(x,MIN(x)))" to get the minimum value for each row that results in an array output. In column C the following does not work "=BYROW(Value_Array,LAMBDA(x,MATCH(B6#,x,0)))" to find...

Hello Guys I'm facing an issue with searching value in excel in VBA. When I search a value, if the value only exist in a1 then below code give me the resul a1. But if same value exist in a1 & in any other cells like in a2 or b2, it gives me the result b2 or a2 i/o a1. Why is this happening...

Good afternoon, I am in need of a formula that will identify the month name in one column from the month number is another column. To be specific, I need the "MONTH" column to show the abbreviated month name using the number in the "MONTH #" column. Any help would be greatly appreciated...

I'm developing a workbook for Risk Analysis. Currently we have a single list/array with several thousand lines. We want to make it more managable, by splitting it according the different departments. But the Risk Theme and specific Risks are identical for all departments. I've created a...

Hi All I am hoping that someone can help. I have been reading the post (Calculate only working hours between two dates excluding weekends) as it was on the right lines for what I needed but I couldn't find the specifics to help me. I have a similar problem with the exception that I work in a...

hi, I'm getting spill results on multiple columns from the below formula. =IF(R2:V2>0,"",O2) but I don't want spill results, I want results in a single column. This gave me a #value error. =IF(@R2:V2>0,"",O2) How can I sort it out?

Ok, I don't think what I'm trying to do is unique, but I certainly can't seem to work it out or find any examples, or even failing that, think of a better way. Sheet One contains cells with Action Groups. These cells might have one action group per cell, or multiple action groups per cell, such...

Hi, i hope someone can help me. I try something similar as already described here: Splitting activity duration by half an hour intervals I too have a long list of activities and their start and end times. What I need is to split the duration of each activity into hourly intervals. At "Normal"...

Hi all, Very new to VBA and trying to learn as I use it. I have searched for this extensively and found a few instances that seem get close to what I need to do, but I still do not know enough to be able to adapt them to my needs. Basically, what I would need is a macro to import data from one...

I have this vba code that I was running previously in Excel 2010 on windows 7. In a nutshell the code is creating a new worksheet and is copy and pasting the recordset into the new worksheet. Then the code will do a lookup and insert new data into that same worksheet. Recently, the business...