| Thread | Last Post | Replies |
|
| help merge documents into a master file | 27 May 2005 00:46 GMT | 3 |
Ok, on my local network \\ I have 5 different Excel.xls documents, doc1.xls doc2.xls
|
| Force users to complete cells | 27 May 2005 00:43 GMT | 5 |
Trying to streamline some of our business processes and we've now put the former paper-based absence forms into excel. Everything is ok but in our testing phase we realised that 'some' managers are missing out a number of key cells - is it possible to somehow 'force' them into
|
| How to take matching data from 2 columns and put in the same row? | 27 May 2005 00:32 GMT | 1 |
First off, i'm not too familiar with alot of functions and commands within Excel yet, so if anybody has help, i'd appreciate it if you talked to me like i was a complete idiot! Every month i extract data from MS Great Plains into an excel spreadsheet.
|
| Copying decimal data to another column to integer 'on the fly' | 26 May 2005 23:16 GMT | 2 |
I am working on Asset registers/Depreciation Schedules and at the star of the year I need to convert over my previous years spreadsheets (fo about 40 schools) to the new financial year. This means moving the accumulate
|
| set a limit | 26 May 2005 23:01 GMT | 2 |
I am a generator mechanic and Im trying to use excel for a maintaince program, the gen set i work on have to be serviced ever 200, 500 and 1000 hours, this is a problem because the gen's run 24 hours a day. Is there a way that i can input the hours of each gen set and excel ...
|
| Filtering | 26 May 2005 22:49 GMT | 3 |
Is there any way to use filter command on basis of colour or select all the cells containing particular colour. Please guide me in this regards. Thanks and Regards
|
| Formula as text | 26 May 2005 22:23 GMT | 7 |
Without changing any of the options to reflect the formula in a worksheet, though an Excel worksheet function is it possible to return the formula in another cell. E.g.
|
| URGENT!!! shared workbook | 26 May 2005 22:14 GMT | 1 |
I have set up a custom form in excel for users to select or type data into that then sends the information to a new sheet in a list format at button click e.g Email only recontact size Budget
|
| Wierd Characters when importing CSV file | 26 May 2005 21:46 GMT | 2 |
I am having a wierd problem with Excel 2003 Proffesional. I have written a program in C# (VS.NET 2002) which I use to export some data in csv format. When I subsequently import this data into excel there is an additional character that appears everytime I have the character 'µ' ...
|
| Copy data from one workbook to another workbook | 26 May 2005 21:35 GMT | 1 |
I want to set up a new workbook using bits of data from existing workbooks. Say data from workbook 'A' cell c21 to new workbook 'C' cell h42, then from workbook 'B' cell f9 to new workbook 'C' cell h43 How do I do this?
|
| deleting arrays in Excel 2003 | 26 May 2005 21:26 GMT | 1 |
I am trying to delete array references in Excel 2003 (accessible via top-left drop-down menu left of the function toolbar). I have been replacing some old arrays referencing external data with new ones referencing external data. It appears that the old arrays are still
|
| URGENT!!! shared workbook prob | 26 May 2005 20:57 GMT | 1 |
I have set up a custom form in excel for users to select or type data into that then sends the information to a new sheet in a list format at button click e.g Email only recontact size Budget
|
| checking celll in column | 26 May 2005 20:40 GMT | 3 |
Hi I need help I want to look for a cell in column if we find the cell in the column “ the value of the cell” write 1 if not write 0
|
| help! How do I restore command bars? | 26 May 2005 20:19 GMT | 5 |
Okay, This may sound like a dumb question but how do I restore the command bars in Excel. I've managed to delete them all while playing about with the following code.
|
| Can't find draw toolbar?? | 26 May 2005 19:20 GMT | 1 |
I need to find the Draw toolbar so I can add lines to a file. No Draw toolbar up on top???
|