rid

All, I am trying to do a sum if by the hour and all I can get with dummy data is by the day. Any one know if I can do this? Equation I am using is =SUM(IF(ISNUMBER('Line 5'!$C$5:$C$44903),IF(INT('Line 5'!$C$5:$C$44903)=INT(B9),--(('Line 5'!$K$5:$K$44703>220)+('Line...

Hi All I have a dropdown in a sheet that just updates my sheet as soon as the user changes a date The problem I have that every time I change the dropdown box - I get this message "You're selecting something that doesn't exist yet...try again..." but the actual figures and everything still...

I used the macro recorder on a protected sheet to copy and paste and I am getting the following error if someone can please tell me how to get rid of it please....thanks for any help Wb.Sheets("Test1").Range("F5:H5").Select Application.CutCopyMode = False Selection.Copy...

I don't get why this is not working, but I am trying to clean up and speed up my code. I currently have this and it works fine within my sub. Columns("O:Q").Select Selection.ColumnWidth = 35.01 Columns("A").Select Selection.ColumnWidth = 6.01 Columns("B").Select...

I have this formula and it's producing the #NAME? error. =IF($C74=”A”,U$79,IF($C74=”B”,U$80,IF($C74=”C”,U$81))) How do I correct this? Thanks in advance

I recently changed the name of a column in a table. When I try to open the table in datasheet form I get "Enter parameter value for "the old column name". How do I get rid of that? tia Jack