Business Software

Recent Answers

2009-11-20 Excel - VBA search using inputbox:

Andreas, Sub FindMultiple() Dim tgt As Variant, sh As Worksheet Dim r As Range, sAddr As String Dim rw As Long tgt = InputBox("Enter String to search for") Set sh = Worksheets("Sheet2") With Worksheets("Sheet1")

2009-11-20 Excel - macros that automaticly calculating values through a workbook system based on values entered into a cell:

The macro sounds fairly easy- it's basically going to be a for...next loop which puts in the values and copies the results to an output array - happy to write it for you, but might need slight guidance

2009-11-20 Excel - Creating column macro (criteria based):

Not a problem - you can use a COUNTIF function to determine the first row, and a sumif to give you the value, with an IF statement to handle the rest =if(countif($A$2:$A$100,a2)-countif(a2:$A$100,a2)=1

2009-11-20 Excel - Vlookup based on several drop downs:

Not sure I have enough to go on in that at the MOMENT it doesn't sound like a lookup, simply an IF statement - but I suspect it WILL be a lookup - the easiest way at that point is to have A12NO

2009-11-20 Excel - Excel 2007 - auto-updating number:

Excellent- your formula has a SLIGHT problem in that presumably the holiday continues in January, february etc - so these would produce a negative number with the formula as it stands =[hours left]+([hours