| Thread | Last Post | Replies |
|
| XML Parsing Error for Microsoft Excel Spreadsheet | 18 Apr 2006 08:24 GMT | 1 |
I am trying to export data from Excel into XML format. So I saved my file using the *.xml spreadsheet format. However when I try to reopen it in a browser, I get an error: XML Parsing Error: not well-formed
|
| macro help | 18 Apr 2006 05:03 GMT | 2 |
I have created a command button in an excel sheet.Now, Im trying to write a macro code that will help a user to locate a particular file in the local directories. i.e When a user clicks the button, a browser window must open up(similar to the 'Save as' button) so that the user
|
| Can I get data from two or more different files? | 18 Apr 2006 03:15 GMT | 1 |
I have several files with the same format. For example, I have different project which is saved in different files. Each have columes named "Problem" & "Solution". All files are put in the same folder and will be create some more when new project is initial.
|
| how to sort between 2 date | 18 Apr 2006 02:14 GMT | 8 |
Please tell me how to data sorted between 2 date by advanced filter. I can only have data larger or smaller than a date but I can't make data in between two date. regards
|
| Sorting multiple columns | 18 Apr 2006 01:55 GMT | 3 |
Howdy everyone, I'm having a problem in excel that I can't figure out, and I thought someone here might have a good solution. Basically what I am trying to do, is take anywhere from 2-10ish columns
|
| If statement | 18 Apr 2006 00:28 GMT | 1 |
Could someone help me write an if statement saying that if the current cell has no data in it to place a o in the cell but if there is a number do nothing. Thank you
|
| How do I create mailing labels from microsoft excel | 17 Apr 2006 23:39 GMT | 3 |
I'm fairly new to Excel. I want to merge names and address information from different colums. Then I want to create mailing labels. Can someone help me with this?
|
| Help: Lost custom macros and won't load personal.xls | 17 Apr 2006 23:26 GMT | 5 |
Using Excel 2002 SP3 under XP-pro SP1. I used a system cleaner and in the process I lost my custom toolbar buttons with macros assigned. Additionally, when I launch Excel, it no longer loads 'personal.xls,' contained in Excel/Start.
|
| Macros & digital signatures | 17 Apr 2006 23:10 GMT | 1 |
Can anyone tell me if macros that are digitally signed would be affected if the person who signed them left a company & their network account was cancelled? Thanks,
|
| Adding Quotation marks to populated fields | 17 Apr 2006 23:06 GMT | 5 |
Hi! I have a spreadsheet with a bunch of columns (A, B, C, D etc.) eac column has 421 fields. In each field is a unique 8-digit number. Now, I need to take the numbers in the fields under Column C and pu quotation marks around them, basically turning this:
|
| Find Missing Number? | 17 Apr 2006 22:48 GMT | 3 |
Ok probably a easy answer here, but I'm a excel Novice. what I have is a series of numbers and what I want to find is what Number are missing in between all the different numbers to complete a whole set of number.
|
| Saving to a csv without the quotes | 17 Apr 2006 22:34 GMT | 1 |
I'm using MS Excel 2003. I have a spreadsheet with a single column of character data (there are no quotes in any of the cells). How do I save out to CSV so that leading and ending quotes are not inserted before and after each cell of data?
|
| Excel wont let me take an old workbook & save as to make a new 1 | 17 Apr 2006 22:24 GMT | 1 |
For some reason excel will not let me do a save as on an old workbook to make a copy it just stops responding?....Rik
|
| Can anyone offer a solution ? | 17 Apr 2006 21:56 GMT | 11 |
Can anybody offer a solution to my problem: I have a list of 4 digit numbers in column A (I need to retain leading zeros for numbers < 1000) I have 19 cells in column B containg alpha-numeric data.
|
| Filter Question | 17 Apr 2006 21:31 GMT | 3 |
I have a spreadsheet in which column F contains descriptions. I need to have on the screen all the rows for which column F contains the word "hospital." How do I do that? Many, many thanks from a clueless person.
|