adds

I have a labor sheet to keep up with my hours each week. The cells below are were Im having trouble. I4 simply has the number of planned hours for each work which is 45 J4 adds all the hours I have entered for each day the formula is =sum(B4:H4) Then the K4 is were my problem is. I have...

I am sure this must be simple, but I can't find a code example that adds a userform using VBA rather than adding it manually in the VB Editor.

Hi, I have worbook with plenty of defined names, each for different sheet. Now i want to increase the range of each of them (they should contain two columns more than they already do). Is there any way that I give list to VBA to go through each of them and adds two more columns?

Hi, I'm building a stock management system, and I need a formula that looks through a range of codes on each worksheet in a workbook. It adds the number in a specified column on the same row, and brings the sum of these numbers back to a summary page. Basically it adds up total usage of...

I have found a lot of solutions for my problem, the strange thing is that when I change the line it works but when I run it again it fails until I change the line again. If this makes no sense good because it doesn't make sense to me either. I have done this a million times and it has always...

Hi... In column A, I have numbers like 1 1 2 2 2 3 3 I call these groups. Group 1 contains two rows. Group 2 contains 3 rows. Group 3 contains 2 rows... and so on. In column F, I need to sum the values that are in column E for each group as indicated in col A. If group 1 adds up to 100...

Hi Could someone help me with the basic concept of an IF function. I need help with a nested if function as I am getting used to them. Basically how do you create a formula in D1 where IF C1 is between 0 and 2.5 it adds 1, if C1 is between 2.5 and 5 it adds it by 5, If c1 is between 5 – 10...

Hi! I'm not too familiar with excel formulas, and I've been banging my head on my keyboard trying to figure this out. I'm trying to create a calculator where someone inserts a time (any time, between (12:00 am - 11:59 pm) and then the calculator adds 2 and a half hours to that time, then two...