| Thread | Last Post | Replies |
|
| Accounts Receiveable Aging | 27 Jul 2007 19:30 GMT | 1 |
We have purchased another company and their programming for their AR Aging report does not accurately apply credits against debits. The report looks like there old invoices due but usually net to zero. Is there a quick function or calculation in Excel that can help with the ...
|
| Re: Excel Formula Help | 27 Jul 2007 19:18 GMT | 5 |
Hi there, I work in the mobile industry running campaigns and so forth. We received the sms entry report in a excel spreadsheet. What I need to do is find the region of entrants. The Entry Data report has
|
| Color Banding | 27 Jul 2007 18:55 GMT | 1 |
I think that this feature got put onto my Excel spreadsheet and it keeps messing it up. Is there anyway to turn that off?
|
| How do I print comments individually? | 27 Jul 2007 18:36 GMT | 1 |
I know that I can print all of them at the end of the document or as displayed on the sheet. I would like to print them individually without having to copy and paste each one in a word document. Also, I do not understand programming. I am fairly proficient with the standard ...
|
| Help! I need a formula to add numbers separated by commas within | 27 Jul 2007 18:24 GMT | 8 |
Hello. I have a spreas sheeit in which each cell has various number seperated with commas. For e.g. 100, 200, 300, 400 are in one cell. I have an entire worksheet in which each cell has multiple numbers and I need for each cell to be summed up individually. So if I have 100, ...
|
| Macro Problem | 27 Jul 2007 17:18 GMT | 6 |
I am trying to use this macro to copy and paste a section of my spreadsheet. It get;s hung up at the indicated line: Range("A1:j29").Select Application.CutCopyMode = False
|
| Calculate Selected cells only. | 27 Jul 2007 17:04 GMT | 3 |
I am not sure if this is the right forum for a VBA question, but I did not find a more suitable one. I have a large workbook that takes a very long time to re-calculate so I am forced to turn off auto calc while working. However I need to re-calc some
|
| Display data retrieved from website and have it update periodicall | 27 Jul 2007 16:53 GMT | 1 |
What function(s) do I use to retrieve data from a webpage? I also want this data to update itself and be displayed in one cell only.
|
| grading | 27 Jul 2007 16:18 GMT | 2 |
What I am trying to do is in put 3 different set of tests. Each on weighing with a % of the total. How do i do a formula to calulate this: Exam 1 Exam 2 Final 100 93 79
|
| sumproduct - multiple conditions | 27 Jul 2007 16:11 GMT | 7 |
I want to get the sum of all transactions in my table of type "RI" or "II" or "AI". I am also filtering for other conditions (warehouse and merchandise class), but these conditions have only one option for each cell in my spreadsheet. In other words, for each warehouse and ...
|
| Summaryt Report | 27 Jul 2007 15:06 GMT | 7 |
I have 3 worksheets in one workbook. Either sheet 1, or sheet 2 will have data in it but not both. The third worksheet is a summary report that I want to draw certain cell contents into ie. Unit #, Serial Number, Make, Model etc.
|
| remove preceding zeros | 27 Jul 2007 14:52 GMT | 2 |
have a series of data with preceding zeros of variable length in column A2:A1000 eg. 000301, 0000034456
|
| spreadsheets | 27 Jul 2007 13:57 GMT | 2 |
on spread sheet after deleting row or row can I automatically move other rows up without using cut and paste
|
| Unexpected #N/A error from INDEX-MATCH combo | 27 Jul 2007 13:13 GMT | 2 |
In our group, we manage people related data with a set of excel files. Normal files extract the people related information (DOB, Emp ID etc.) from 2 master files using the name as input to an INDEX-MATCH combination. Problem is, it is working only in 99% cases. In some
|
| Paste Specil function in excel 2003 | 27 Jul 2007 13:10 GMT | 1 |
when I try to copy columns from my on line trading account to excel format with Paste Special in 'text format' it used to do the job perfectly filling in data in each cell. Recently, i reloaded my operating system and now the paste special function does not work in the nsense ...
|