| Thread | Last Post | Replies |
|
| Transfer Files Using VBA | 23 Feb 2006 01:38 GMT | 4 |
I'd like to transfer files from several drives on my pc to one cetnral location. From A:\Office1\
|
| SUMIF bug in Excel 2003 | 23 Feb 2006 00:59 GMT | 2 |
If file "A" is linked to file "B" using SUMIF function, then if file A is sent to some one else who does not have file B. If file "A" is opened by clicking no for update links dialog, it will show "#Value#" in the cells linked to B. This problem is not there in Excel 97. We
|
| Hyperlinks to files on network drivers | 22 Feb 2006 23:10 GMT | 3 |
I have a problems with creation of hyperlinks to files on company network drivers. I have a name for a link in a cell. Than I follow routine and press hyperlink button, etc. Pressing OK and created.
|
| Convert - lbs to kilo... | 22 Feb 2006 22:39 GMT | 1 |
I'm just wondering if anyone is aware of a spreadsheet that contains the convert items within excel? Like Pounds to Kilo.. ?
|
| phone numbers | 22 Feb 2006 22:27 GMT | 2 |
Hi I'm stuck on this one I want to add a 1 to my phone list. I have removed all spaces and other signs to create a number such as from (201) 276-2143 to 2012762143 Now I need to add a 1 to the whole column of about 52,000.
|
| How do I assign dollar value to text | 22 Feb 2006 22:06 GMT | 3 |
I am putting together an invoice spreadsheet for Voice Overs. I want to be able to type :30 in Column D and have the value of $35 to appear in Column F. Subsequently, If I type :60 in Column D the value of $50 will appear in Column F, and :90 equals $75 and so on. How do I assign ...
|
| Calculation not working | 22 Feb 2006 21:11 GMT | 4 |
I have entered a RIGHT function, when i go to Insert, Function command and do RIGHT(G3,2), calculation shows up correctly in function box, but does not calculate in cell itself. Still displays command RIGHT(G3,2) What am I doing incorrectly? Have checked Tools, Options, ...
|
| looking for a keyword/function name/example | 22 Feb 2006 20:41 GMT | 3 |
I'm hoping this is basic, and someone can just give me a one shot example I have a worksheet, the first col going down are dates 2nd col are prices A B 1 4/21/06 20$
|
| Need help, clueless | 22 Feb 2006 19:42 GMT | 1 |
I have just started using excel and im running into, what probably is, a simple problem. This is exactly what I need. I have two sheets (February & March). I want the number in February B8 to copy into March B3.
|
| Duplicate numbers | 22 Feb 2006 18:57 GMT | 8 |
I am doing a copy and paste with phone numbers on my spreadsheet. I then manually have to search for duplicates. I there a way that excel can do that for me? Also, When I copy phone numbers, I must copy one number, go to spreadsheet
|
| Excel help please | 22 Feb 2006 18:45 GMT | 4 |
How to add clip art in excel behind text & grid lines?
|
| Export to Text file. | 22 Feb 2006 18:14 GMT | 2 |
Please help me. I writen this VBA code for export range to Text file. -------- Option Explicit
|
| Please advise why I get an Error Message "Prop Res DLL" | 22 Feb 2006 18:10 GMT | 1 |
When I try to open certain Word documents I get an error message that says "PROP RES DLL". After clicking the OK button several times I get another error message stating "the printer has not responded...........Do you want to continue to wait" and with a Yes No box. If I click ...
|
| LOOKUP but with 2 parameters ? | 22 Feb 2006 17:48 GMT | 1 |
on sheet2, i have the following table col1 col2 col3 A 1 10 A 2 11
|
| VBA code question? | 22 Feb 2006 17:47 GMT | 1 |
I have this simple 3 subs vba code. It runs 8 times and each solution has 24 values that is put in one column of 24 raws. So, the 1st solution found gets written at N2 to N25....and so on. The problem I have is this: The 1st solution that gets written from
|