help

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)

Hello! I am probably doing something wrong but I keep getting an error and I dont know how to fix it. The long and the short of it is I have to copy data between three different excel workbooks Dim wb1 As Workbook Dim wb2 As Workbook Dim wb3 As Workbook ' Set wb1 = ActiveWorkbook Set wb2 =...

Hi all, I have an open workbook with three sheets called "1", "2", and "3". I want to hide these sheets and make it so that you cannot open or view them without a specific password. Right now, I can protect these sheets. However, protecting them means that you can still click on the sheets...

Hey I'm writing a VBA function to generate a couple reports in a consistent printable format. Everything is working fine thus far except that variable functions I am inputting into a cell are adding an @ symbol and breaking the function making it have to be manually fixed. Is their a way to make...

I dont understand why my taskbar here is so big i tried googling it, but nothing works also the taskbar is normal size on the other two monitors

I would like to consolidate columns A2:I2 based on the criteria that A2:D2 are the same on the next row. I have attached photos of the whole document to provide how this is supposed to work. I cannot seem to figure out consolidation and I maybe overlooking it. I have the code pasted below...

Hello! I am fairly new at messing with Excel beyond the very basics. I have a schedule at work that I would like a specific worksheet to require a password each time it is opened. Sadly, the problem is that using the build in protection in Excel, some of the individuals who require access to...

Hello Wondering if an Excel expert can help. I'm wondering if this might be due to an update but i'm not entirely sure. I have a workbook at work which is used to track absence. There is a master data sheet which is refreshed with a system report every day, so on the absence sheet, all the...

Hello I am trying to track my energy usage and have a spreadsheet with two sheets ABCDEFG1No.Period FromPeriod toElectricGasVATTotal2101-Mar-2229-Mar-22 ABCDEFGHIJ1No.Period fromPeriod toFuel / StandingTypePrevious ReadingLatest ReadingUnits UsedKWH Rate or Standing Charge Daily Rate...

I've been racking my brain trying to figure out a formula for this. I've included borders to help illustrate what I need. I'm trying to sum column P based on the month in Q and subtract it from the debited amount in column S to get my monthly total in column T. I tried doing a SUMIF but as...

Greetings, I am somewhat lost how to approach this problem that I have. In essence I want to calculate demands per material for specific date based on the number of projects on that date. for this I have 3 tables Project Consumption Table (showing how much of each material is consumed for each...

Hi all, I have a lot of cells that look like this: Now, what I would like, is to have a formula that returns ONLY the top part of cell A3 I have separated the texts by pressing ALT + ENTER and then typing: Test 1 Test 2 Test 3 instead of Test 1 Test 2 Test 3 Is there a way in which I...

Hello, The below macro is assigned to a button on the ribbon and works on the "current 6 months" sheet. It looks down column B for "terminated" and deletes the row. It's currently restricted to only work on "current 6 months" sheet. Is there any way to add another sheet "Previous 6 months" to...

Beginning of month 01/01/2022 01/02/2022 01/03/2022 01/04/2022 01/05/2022 01/06/2022 01/07/2022 01/08/2022 01/09/2022 01/10/2022 01/11/2022 01/12/2022 Net working days 21 20 23 21 22 22 21 23 22 21 22 22 This part data and I have a separate sheet where I am gathering data for each month...

Hi everyone, Every month I get this table (Clients) where I am given costs broken out by rows of clients and columns of weeks. However, I need to summarize these values by Client and Month instead of week (Sheet2). Pivot tables don't seem to read across columns and my current sumproduct...

Hi all, I have this setup at the moment: However, when I search for "14-06-2022" I get a sum of 9964136,14 because my SUM formula takes all the hidden rows into account When I plus all the numbers I get the correct amount of 372344,76 But it takes a lot of time to write "A1 + A101 + A102 +...

Hi, I'm trying to create a macro that will replace all the "1"s in a column with a value in Range "A1", then move onto column 2 and replace it with the value in Range "B1" and so on. this is what I have so far Sub Macro2() ' ' Macro2 Macro Dim X As Integer X = InputBox("What column...

Hi all, I hope the title makes somewhat sense, but allow me to elaborate. I have a setup like this: I want my numbers in column D to replace whatever value is in column B However, if I mark all of column D and move it other to column B it will say the following: If I say yes to this, I...

Hi all! I am currently comparing values in two sheets to each other to see if they are similar or dissimilar. I have this setup at the moment: My formula is: =IF(COUNTIFS('[CONFIDENTIAL - NUMBER.xlsx]Sheet1'!$T$2:$T$1712;E2;'[CONFIDENTIAL - NUMBER.xlsx]Sheet1'!$R$2:$R$1712;A2)=1;"yes";"no")...