| Recent Answers |
 |
|
2008-10-12 Excel - Input dollar amount into a cell that updates another cell and more: Bill I usually do this by using the copy/paste special/values feature, so when you create the new number it can then be added to a third number and then copied to your cell A2. You can create a macro...
|
2008-10-12 Excel - formula for employee hours in and out: Hi Estrella How are you? Your problem is that you typed 1700 (the one thousand seven hundredth hour). You have to separate the hours, minutes and seconds with :: Please do the following 1. Write...
|
2008-10-12 Excel - User Form: Zsoft, Not sure what you mean here. Do you mean you want three listboxes or you want to make a selection between approved, unapproved, superseded. Anyway, a listbox can only show 9 columns unless...
|
2008-10-12 Using MS Access - Prevent a record from being captured when insufficient stock available: Well, first, I'm sorry to say that your application is not properly designed. You should NOT have a table like tblStockList. Stock on hand is a calculated value and, as a general rule, we don't store calculations...
|
2008-10-12 Excel - How to search for multipe rows based on a single criteria and concatenate them into 1 cell: Follow the original solution... except in Sheet1 cell C2, the formula is: =B2&IF(ISERROR(MATCH(A2,A3:A$1000,0)),"",", "&VLOOKUP(A2,A3:C$1000,3,0)) Why don't you want to add a column? You can put...
|