Hot answers tagged

3

Table1[#All] includes the headers, Table1[Code 2] and Table1[Code max] do not. Instead of Table1[#All] just use Table1.


2

You can use an IF and an OR to make sure either WEEKLY or BILLS are populated: =(IF(OR(B3>0,C3>0),D2+B3-C3,"")) This checked if B3 or C3 are over zero. If one of them are, it'll calculate, otherwise it'll show an empty string.


2

As mentioned by Máté Juhász, =VLOOKUP can be used with some data shifting. From the KB on vlookup Syntax - VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) range_lookup (optional) A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match: TRUE assumes the first column in the ...


2

It looks like the button became unassigned from the macro. Try reassigning the button to the macro. When you first right click on the button and choose Assign Macro, if you look at the "Macro name" text box, it should show you what macro is currently assigned to the button.


1

Here's one solution: Let's say User enters their date in E1. F1 contains =DATE(YEAR(E1),MONTH(E1)+1,1) G1 contains =DATE(YEAR(F1),MONTH(F1)+1,1) H1 contains =DATE(YEAR(G1),MONTH(G1)+1,1) (I shortened the month names for this next part) You can use the CHOOSE function to provide a list of choices - one of which will be selected based on the number ...


1

That workbook event is available in 2010 also. MSDN 2010 link https://msdn.microsoft.com/en-us/library/office/ff840057%28v=office.14%29.aspx


1

Sub HideRows() Dim RowCount: RowCount = 1 ' Row you wish to start from Dim ColIndex: ColIndex = 1 ' Column to look within (A = 1) - Never will be in ColIndex + 1 Do If (LCase(Cells(RowCount, ColIndex).Value) = "no") Then Cells(RowCount, ColIndex).EntireRow.Hidden = True ElseIf (LCase(Cells(RowCount, ColIndex + 1).Value) = "never") Then ...


1

I also had the same type of issue and this is what worked for me: Private Sub CheckBox1_Click() If CheckBox1.Value = True Then CheckBox2.Value = False CheckBox3.Value = False End If End Sub


1

In your example, dragging the formula from column F to column G will change the formula to "('Time sheets'!H10-'Time sheets'!G10)*24". You are trying to increment the columns in the formula by two, which can't be done by simply dragging, only by dragging over two columns and then deleting the intermediate column, or by VBA programming.


1

Here's a solution that requires a minor edit of your data collection table. Re-format table with only necessary columns and rows (i.e. NO summary/subtotal rows). I've added two columns, one to calculate your subtask, based upon your detail column. The other calculates your overhead time by looking to see if there's a delta (created by a start/end time in ...



Only top voted, non community-wiki answers of a minimum length are eligible