General

How to gernerate invoice numbers in EXCEL?
Have created an Invoice and am trying to generate a continous invoice number every time I type a new name. ... 15 Apr 2010 22:35

Sort blocks of data
Can you assign groups of columns to move together when sorting horizontally? I have 11 groups of columns each group with an amount column, ideally we have the list sorted from left to right descending dollar amounts for the amount column from each column group. Any ideas are much appreciated. -- "Gambling is... 16 Apr 2010 08:22

Excel 2007 missing data using auto filter
I have activated my DATA - Filter. It is not displaying all different types of items within the column. I have about 1600 rows of data. Not all rows have an entry. The first data I am missing appears on row 504. I have tried reformat the cells to make sure they are general formatting. Any thoughts? ... 16 Apr 2010 10:35

Calculation help
I want to calculate production numbers I have the actual production number in F5 (115 peices) I have the time duration in I5 (:59) I need the average per hour in J5 Can someone help please If more info is required please let me know Cheers!!! ... 15 Apr 2010 19:15

Excel - Expense tracking-multiple users
Have 7 ppl sending me bi-monthly expense updates via Excel. Then I have to take all their "new" updated data and incorporate into a Master .xls, which the 7 ppl can't access directly unfortunately. Problem is, when I get the updates from the 7 ppl, I need to be able to see what is "new" data since their previou... 15 Apr 2010 19:15

Formula adding 2 days...
So, here is the formula I'm using. Some cells it's adding 2 or 3 days to the MONTH and some cells it's not. I don't WANT it to add 2 days. It should just be adding 5 years and leaving the month and day the same... what is happening here? =IF(J5="","",DATE(YEAR(J5)+5,MONTH(J5),DAY(J6))) ... 15 Apr 2010 19:15

Formula Help...
I'm calculating a date 5 years in advance for a lot of cells. If the original (J4) date is blank how do I tell it to leave the new date blank also? Does that make sense? Thansk. =DATE(YEAR(J4)+5,MONTH(J4),DAY(J4)) ... 17 Apr 2010 10:47

SumProduct counting negative numbers
I have 2 columns as follows: A B -$24.00 n/a $200 n/a $350 n/a $65 9.30% $32 n/a n/a 5% i need a function that will count the number of times column A appears with n/a only ( so in this case its 4). I have this so far...i don't know how to write it so its counts the negative val... 15 Apr 2010 18:07

How do I move contact info from excell to Outlook?
I have a basic spreadsheet with contact information in separate columns. name, postition, phone, address, email. I want to move each individual with their information into an entry in Outlook contacts. Can it be merged? ... 15 Apr 2010 18:07

Copy and Paste Macro
I am attempting to create a macro to copy and paste. The cells I need to copy are not adjacent to each other. I used the Ctrl key to select the cells but I get an error that it cannot be done. How do I select and copy these non-adjacent cells in a macro? ... 15 Apr 2010 19:15