| Thread | Last Post | Replies |
|
| why my columns in excel are no longer alphabetized? | 30 Apr 2008 14:59 GMT | 5 |
My columsn are numbered. They are no longer alphabetized. I am using excel 2007 and I have no idea why this has happened. Please help.
|
| Find function > Pivot Table | 30 Apr 2008 14:58 GMT | 1 |
I am having some problem with the find function. I have a template and a report. On the basis of this report i hve prepared a pivot table. Now what i need is to search the pivot table and if value is found then paste the value frm pivot to template.
|
| Turning a time value into a numeric value | 30 Apr 2008 14:45 GMT | 3 |
I have a calculated time value which records the time I spend on database work for a client. it shows the hours worked in the cell as "6:45" (6 hours and 45 minutes database work). CELL A CELL B CELL C
|
| Hopefully a simple macro to precatenate data in a column | 30 Apr 2008 14:33 GMT | 7 |
Sorry if this is really easy or not possible. I'm a dba with very little Excel experience. I've been given an Excel spreadsheet to import into a relational database there are some data consistency issues... Anyway, what I'd like to do is insert an underscore at the front of the ...
|
| EXCEL freezes during "save as" | 30 Apr 2008 14:27 GMT | 3 |
Hello! My EXCEL 2003 freezes during the "save as", as such unable to reach the desired drive letter. Any solution to this very much appreciated. zhj23
|
| how do i either import or export address info for dynamo lables | 30 Apr 2008 14:23 GMT | 1 |
how do i either import or export address info for dynamo lables
|
| Incorrect auto sum | 30 Apr 2008 14:20 GMT | 2 |
Can someone help me figure out why I routinely get an incorrect total at the bottom of a column after using autosum?
|
| Replace several words to One | 30 Apr 2008 13:56 GMT | 2 |
Hello How do I correct the macro below. I want to change the words FXG, FXR, GFX, and FXT to say FAX Thank you thank you Range("C1:C3169").Select
|
| Exel 2003 | 30 Apr 2008 13:35 GMT | 1 |
Hi All i am back i have got my form set up in exel i know wish to use it but i do not need the the rest of the exel grid i just need the form that i have made up to send to my agents so that they can fill in the info that is needed i need them to be able to save the form on the ...
|
| Raw data into a pre-defined template | 30 Apr 2008 13:29 GMT | 5 |
I recieve a extract on a daily from an Access MDB. The extract is in the form of an excel spreadsheet. Depending on the day, The spreadsheet may contain 5 different categories of information. Each category may or may not caintain any data.
|
| How to rid of User name from Comment Notes? default now | 30 Apr 2008 13:29 GMT | 1 |
For some reason excel is setup to input my user when ever I insert a comment note in a cell. So each time I have do delete the user name, before inputing my comment. Is there a setting in excel to take that option off. thanks.
|
| PIVOT TABLE - GROUPING DATES | 30 Apr 2008 13:26 GMT | 1 |
I have a sheet of records nearly all filled. When I try to add the dates' field in the PIVOT TABLE it is informed that PIVOT TABLE won't fit in a new sheet although I require to add the same for gouping of records year-wise.
|
| Format Date in Cell with Text | 30 Apr 2008 13:13 GMT | 1 |
I have a named range, DT, which contains a date value. I wish to display in a cell: ="Revenue Account Summary As Of " & DT But I get "Revenue Account Summary As Of 39566". How can I format the Dt in
|
| dropdown list contains 5 items want to add 100 how | 30 Apr 2008 12:50 GMT | 1 |
I have an existing dropdown list containing 5 rows with data ,I want to add 100 more items how do i do so thx vince
|
| vlookup: source is specific and table is a range | 30 Apr 2008 12:07 GMT | 2 |
my template calculates a specific value, ie 1,357 or 12,789. The rates I apply to these values are based on the range that the value falls into, ie 0 < 1,500 0.145 1.5<2.5M 0.130
|