| Thread | Last Post | Replies |
|
| Bridge data from Website into Excel | 03 May 2006 20:27 GMT | 4 |
I am trying to come up with a simplified way (instead of copy and pasting thousands of lines weekly) to pull data from a specific web site and pull the data into an excel file. Where I can I begin to find information on this topic? Is there a way
|
| Searching for a specific string | 03 May 2006 20:05 GMT | 1 |
I need to extract a specific string of data from about 300 cells, and copy that string from each cell to another cell. This is what I think the search string should be "DIR:*;" The * indicates where a 7 digit number will be with an _ and a username. Is there a way to do this?
|
| Different Column widths | 03 May 2006 19:57 GMT | 3 |
Can a spredsheet have different column widths within one column? I'm trying to set up a form. I dont need to use any formulas at all in this sheet. Thanks,
|
| Changing the background color of my Word Screen | 03 May 2006 19:57 GMT | 1 |
I don't know how messed this up, but the background of my Word Screen used to be purple. Somehow now it is gray. I tried looking under "options" to see how I could change this back, but there is nothing under options that would accomplish this? Can anyone help? Also, if it ...
|
| Date Format | 03 May 2006 19:32 GMT | 3 |
I copy a SQL Query output and place it into Excel. The time column shows dates as 4/7/2006 4:02:10 AM, 2/28/2006 10:37:39 AM, 3/1/2006 1:56:40 PM. IS there a way to get rid of the hr, min and secs ? I used the format
|
| macro when there is none | 03 May 2006 19:19 GMT | 2 |
Just recreated a book, that used to have a macro in it. I have not had the time to put the macros into the new version, yet it keeps telling me that it has a macro in it when I go to open the file. I can't seem to find any references to any macros in it. Am I missing something ...
|
| text to rows | 03 May 2006 18:47 GMT | 5 |
I there a way to put text to rows instead of columns? What I am trying to do is take a cell with reference designators separated by commas and copy them to individual row. ex.. C1, C2, C3, C4
|
| Advanced Pivot Table | 03 May 2006 18:45 GMT | 1 |
I am trying to prepare a pivot table wherein I am not sure where I am missing my eyeballs ;) The first tab sheet contains data as below. SBU, Domain, project,Emp#, Empname, exp in years, exp in months, exp
|
| MATCHING COLUMNS | 03 May 2006 18:19 GMT | 2 |
I HAVE A QUESTION ABOUT MATCHING COLUMNS IN EXCEL. FOR INSTANCE I HAVE TWO COLUMNS ONE IN A AND ONE IN B WITH ALL DIFFERENT VALUES. HOW DO I MATCH COLUMN A WITH COLUMN B? AN EXAMPLE IS BELOW A B
|
| uk tax calculator | 03 May 2006 18:19 GMT | 21 |
hello i'm trying to make a wage calculator in excel that works out your tax and NI ( UK ) i think i need to work a formula out on my topline but not sure how to do this as my wages are diffrent each week. please help
|
| Copy column widths from one spreadsheet to another | 03 May 2006 17:34 GMT | 1 |
I need to copy (reapply) the column widths from my formatted spreadsheet to another one. I get an new copy of the spreadsheet each week from our finance admin with updated data and I want to copy over just the column widths (and if possible hide certain columns) without
|
| How do I make postcards using Powerpoint | 03 May 2006 16:47 GMT | 1 |
I am trying to make postcards to send out to my clients and I need to find a format to use on Powerpoint, can you help me figure out the steps I should take to make postcards.
|
| Problems with re-setting the last active cell in an Excel workshee | 03 May 2006 16:46 GMT | 2 |
I am trying to re-set the last active cell on an Excel 2002 worksheet (in this particular sheet it should be cell DA197). I have used both the methods described in the Knowledge Base article (deleting rows and columns and re-saving; and the Excess Format Cleaner add-in).
|
| Erase All Empty Rows | 03 May 2006 16:28 GMT | 2 |
Hi All; I prepared a data file but there are a lot of empty rows under the data. Is there any way to erase all them? Regards
|
| Multiply hours:minutes by cost/hour to get total cost? | 03 May 2006 16:08 GMT | 4 |
How does one do a simple function to multiply a time (in hours:minutes i.e. [hh]:mm) by a cost per hour (i.e. $60/hour). If I have the time in one column, and the rate per hour in another column, I need the total to be the total cost (i.e. 10:50 times $60 = sum??? should
|