| Thread | Last Post | Replies |
|
| Looking for certain months and summing the totals | 30 Jan 2008 17:44 GMT | 10 |
I need a formula to first look for all of january date, febuary dates, etc. and total them under check amount column. Hope this is clear.thank you Amount Date Check Amount Month $320 1/29/2008 $1,886.24 Jan
|
| Assigning macro to toolbar - only works sometimes! | 30 Jan 2008 16:47 GMT | 4 |
I have recorded a few macros for my colleague, i have sent the file across in which the macro was coded and have advised my colleague to assign the macro to a toolbar button. He assigned the macro to a toolbar button but finds that each week he needs
|
| VBA Function | 30 Jan 2008 16:46 GMT | 7 |
How to combine 3 macros to run together. First, I would like to unprotect all sheets for which I am using the following macro: Sub unprotectAll() Dim myCount
|
| Data Validation error message | 30 Jan 2008 16:28 GMT | 1 |
I have set up a data validation to include a drop down box of a list of yes or no on my question. I have also set up a conditional format to color the box in if the answer is no. however I'm having trouble getting the error message box to flag up if they select no. I thought I ...
|
| Count of a time range | 30 Jan 2008 16:01 GMT | 13 |
I have a list of times 0:00 - 24:00 and days and I need to find out how many files were processed between in an 8 hour shift per day Entry Number TIME Est. Date of Arrival 9065233-5 14:56 1/1/2008
|
| Before Save code | 30 Jan 2008 15:57 GMT | 4 |
I have an excel spreadsheet where I have cells that are mandatory to fill in. I used the Before Save code in Thisworkbook and it worked. Now how can I suspend this action so I can save the file myself?
|
| Adding workdays | 30 Jan 2008 15:42 GMT | 1 |
I need to add networkdays to a date that will return a date (example: start date 1/1/08 plus 10 networkdays = 1/15/08 because 1/1/08 is a holiday and 4 days are weekends).
|
| IF Function to enter background colour and border to a cell | 30 Jan 2008 15:37 GMT | 1 |
Is it at all possible to set up an if function to have a cell become a certain background colour and to have a border added to the cell?
|
| The right formula is? | 30 Jan 2008 14:58 GMT | 2 |
I'm trying to put together a complex weight chart to record a few different items for my wife and I, been so long i cant remember the correct formula to calculate plus and minus weights in the same column as below. B2 B3 B4 B5 ...
|
| Crazy If | 30 Jan 2008 14:44 GMT | 1 |
Looking through multiple worksheets: I multiple worksheets (at least . Each worksheets has the same data and different data. Example:
|
| Linking cells in different spreadsheets | 30 Jan 2008 14:31 GMT | 6 |
I want to link a number of cells from different spreadsheets into one main stock control spreadsheet and I've no idea how. Any suggestions? ie Stock control = 200 Order Number 50
|
| Formula to record the date | 30 Jan 2008 14:03 GMT | 12 |
I've been working with the following formula: IF(B2<time(14,0,0),today()+1, today()). What the formula should do is determine if it is before 2pm on a given day then put today's day. If it's after 2pm then put tomorrow's date. I have
|
| avoid embedded if statements | 30 Jan 2008 13:07 GMT | 3 |
Is there a quick way to do multiple if statements rather than using an embedded if statement? I have the following: If A1 = 1 then write carpet, If A1 = 2 then write couch, If A1 = 3 then
|
| copy data of two cells from Sheet 2 into one cell in Sheet 1 | 30 Jan 2008 13:00 GMT | 6 |
I have a workbook with multiple sheets, the first sheet is a summary sheet. I'm trying to copy data from two separate cells in one sheet to one cell in the summary sheet. CLARIFICATION: From Sheet 2 I have data in cells K33 & K34. I need to have
|
| choose table_array in VLOOKUP from list of multiple worksheets? | 30 Jan 2008 12:56 GMT | 5 |
I'm looking to search multiple worksheets labeld by date using the vlookup function. I'm using the drop down, and I want to know if there is a way to reference the drop down to a list of ranges, or have that drop down be a changing reference to in the table_array section of the ...
|