| Thread | Last Post | Replies |
|
| How to export to "data-1","data-2","data-3" format ? | 25 Feb 2005 21:51 GMT | 2 |
I need to create a delimited file where each field is delimited by a comma and each field is contined in double quotes... like... "data-1","data-2","data-3","data-4", etc Can I do this from Excel?
|
| Building a Hotlink from a formula | 25 Feb 2005 21:38 GMT | 4 |
Hello. I have tried a few unsuccessful runs at this, so was wondering if anyone who has done this could help me out. Workbook A contains one tab per person, with a detail record of assets assigned to that person. I've named the Tabs (manually) according to
|
| Saving worksheet as CSV after pulling data from an external data source | 25 Feb 2005 21:09 GMT | 4 |
All, I am trying to load an Excel workbook. Have that workbook update from an external datasource (oracle). Then save as a CSV. I have tried putting code in the "on workbook open" but code is run before
|
| Copy and paste from Vertical to Horizontal | 25 Feb 2005 21:00 GMT | 3 |
Does anyone know how to copy a vertical column from excel and paste it into a horizontal row? I have a sheet with column A 1-256 filled in and I want to copy and paste it into a new sheet using row 1 A-ZZ etc. Can this be done?
|
| Can I safely enter information on two worksheets simultaneously w. | 25 Feb 2005 20:47 GMT | 1 |
I am setting up a database that lists informationa about different contract employees. The first worksheet will be a summary and then there will be a worksheet for each employee. The goal is to have a running count of the work each has done. If I have a summary line on each ...
|
| **Commission Calculation Problem** | 25 Feb 2005 20:20 GMT | 1 |
I need help on two things: Firstly, I am calculating a new business commission of 1% over a 3 month basis. If the campaign doesnt run as it should in the fourth month a clawback will
|
| Option buttons and check boxes moving | 25 Feb 2005 16:54 GMT | 3 |
I have encountered a problem with forms I construct in Excel. When I print the form it will print one time okay but most of the option buttons, check boxes, combo boxes, etc will jump to the left side of the window and I must close the form without saving or the form will be ...
|
| Excel Formula Reference? | 25 Feb 2005 16:10 GMT | 4 |
I'm looking for a decent MS Excel reference for formulae - preferably one with examples. I'm coming from a novice but fast-learner angle. Has anyone suggestions - online or bound? Regards
|
| Automatic refresh of external data | 25 Feb 2005 14:20 GMT | 4 |
I've looked and played with all the settings that I think would allow automatic refresh of external data, but I still get a dialog box every time I open the workbook that asks if I really want to enable or disable automatic refresh. Yes I really do! Where is the switch or property ...
|
| Become formula. | 25 Feb 2005 14:19 GMT | 5 |
A B C D E 1 1 1 1 1 2 3 4 5 6 3 6 10 15 21
|
| =hyperlink() for mailto: | 25 Feb 2005 14:05 GMT | 2 |
is there a way to use the function =HYPERLINK() with URL longer than 220 characters? I did tryied a lot but it returns #ERROR and the link does not work anymore until I reduce string size.
|
| Extracting hours from time | 25 Feb 2005 12:38 GMT | 2 |
Sorry I seem to have a problem getting my thick head around this. I need to enter a starting time then a ending time i.e.. 4pm to 9.30pm, A formula to calculate the amount of hours worked eludes me.
|
| Excel to Access | 25 Feb 2005 12:34 GMT | 1 |
How can we transform Range of cells from excell to access table? i.e. name number1 number2 number3 .... John 50 60 55
|
| STDEV down, but not across, two cols?? | 25 Feb 2005 11:32 GMT | 2 |
I don't understand Standard Deviation very well - I was just told to use this function. Up 'til now, I've only had one column of numbers. Now I have two columns of five data points each. Each set across is one pair (two measurements of the same item).
|
| Deleting or Adding Zeros | 25 Feb 2005 11:27 GMT | 1 |
I have two lists in CSV format that I need to join tables in Access. One list, which is too large to open in Excel has no zeros at the end or a letter. The other list has zeros or a letter. How can I add zeros to one list or delete zeros from the other list?
|