| Thread | Last Post | Replies |
|
| VLookup based on two criteria | 28 Aug 2007 22:22 GMT | 2 |
I've read through many posts on this topic but I've not been able to find a solution to my problem. On one tab I have six columns of information (table_array.) Column "A" contains a machine name, Column "B" contains a fault name and
|
| How do I force quote marks when exporting to a csv? | 28 Aug 2007 21:57 GMT | 1 |
When exporting to a csv file, Excel only places the double quote marks around certain fields. I need it to place quotes around all fields. Is there an option to specify that?
|
| Drop Down Lists | 28 Aug 2007 21:56 GMT | 1 |
How can I select from my Drop Down lists by starting to type in the word? For example, when I type in 'G', the names in the list beginning with 'G' will be selectable, when I add 'a'; I should be getting closer to selecting 'Gate' - for instance.
|
| Data validation: wider window on 14 columns | 28 Aug 2007 21:30 GMT | 3 |
I need 14 columns to temporarily expand so a data validation window can be read. Can the following solution from http://www.contextures.on.ca/xlDataVal08.html#Wider be used on multiple
|
| Error checking | 28 Aug 2007 21:29 GMT | 3 |
I have a file in one column we have Make and in the other column we have Model. on a seperate work sheet there is a list of makes and models. in the make column when you click on it there is a drop down list of all the makes on the second work sheet and in the model column there ...
|
| ENCREMENTAL FORMS | 28 Aug 2007 21:25 GMT | 2 |
Okay, this is what I want to do. There are three sheets, a Req Log a Requisition form and a PO Form. I want to create incremental forms from the Req Log. So that each Req number has its own Req and PO. Can this be done in Excel? I can do it manually by creating a REQ or PO and ...
|
| Large Database Problem-linking worksheets and printing | 28 Aug 2007 21:08 GMT | 1 |
I have a very large worksheet. My aim is to have Excel print automatically the first Column and one of the Columns that follows. For example Page 1=Column A & B,
|
| lookup part number in a vertical list and return the most recent . | 28 Aug 2007 21:07 GMT | 4 |
I need to lookup a part number in a "shipment Log" worksheet. It is laid out with the following column headers: "Part Number" "Aug 1" "Aug 2" "Aug 3" etc.... If a part has been shipped, there will be a value under the appropriate date
|
| Removing the " [Group] " from a saved file | 28 Aug 2007 20:54 GMT | 2 |
I was working in an excel file, and then I noticed that [Group] had been added to my file name. As a result, I cannot switch tab pages, and I keep getting different highlighted blocks in the file.
|
| Inserting Multiple rows | 28 Aug 2007 20:48 GMT | 2 |
Can I insert 15 rows one time, instead on insert row, insert row etc....
|
| Automatic numbering | 28 Aug 2007 20:42 GMT | 1 |
I need automatic sequential numbering each time I open my Work Order. Is there a way to create the sequential numbering automatically each time I print, so I don't have to close the worksheet? I have absolutely no idea how to write or use a macro. Not that I'm not
|
| retrieve items deleted from recycle bin | 28 Aug 2007 20:37 GMT | 1 |
I accidently deleted the main spreadsheet my desktop shortcut was connected to. Not only did I sent it to the recycle bin, but emptied it also. Is there any way possible I can retrieve my file or am I out of luck?
|
| Excel Pivot Table - Sort Report Filter Values | 28 Aug 2007 20:26 GMT | 2 |
I'm using Excel 2007. I have built a pivot table. I have a field in the Report Filter section of the pivot. There are about 95 values in this drop-down. Problem: The list isn't sorted in alphabetical order. Or rather, for the
|
| Populate Data w/ Multiple Drop-Downs | 28 Aug 2007 19:54 GMT | 1 |
I have a workbook that has a "master" worksheet with all the data (it is ever expanding column wise). Right now it is 36 rows by like 150 columns. What I need to do is create another worksheet in the same book that is linked to the master worksheet. On the new worksheet, I need ...
|
| Restricting data entry to A-Z a-z 0-9 | 28 Aug 2007 19:33 GMT | 10 |
Is there an easy way of restricting the data that can be entered into a cell so that only characters that are in the range A to Z a to z 0 to 9 are valid. i.e !"£$%^&*()-_ etc etc are not allowed? Might also need space to be an allowed character, not sure yet.
|