| Thread | Last Post | Replies |
|
| How do I inventory my computer store | 31 Dec 2006 23:24 GMT | 7 |
I need the best form to use with Office 2007 to inventory my store. I have some tools, lots of parts...
|
| Dial Phone from Active Excel Cell | 31 Dec 2006 20:52 GMT | 1 |
I'd like to dial a phone number contained in the current cell in Excel 2003. I have a voice modem. I've Googled and searched microsoft.com and I can't find it anywhere, if it's possible at all. I've see shareware that makes it possible, but if I can't
|
| Chart Labels Don't Show | 31 Dec 2006 20:49 GMT | 3 |
This is really a beginner question I am sure. Would really appreciate some help. When I create a chart in Excel 2003, sometimes the plot area is too small and crowded and not all my data labels show up. Is there any way other than dragging the corners to make the chart bigger ...
|
| Couldn't find data form dialog box in Excel 2007 | 31 Dec 2006 17:54 GMT | 3 |
Can't find data form dialog box in excel 2007. I need to enter data using data form dialog box. Any suggestion? Mosaddeq Aziz
|
| validation list became not working. | 31 Dec 2006 17:12 GMT | 4 |
i have an excel with lot of validation lists in severals sheets. while working with the excel i all the validation list in specific sheet became not working.the list are still defined in other sheet. but there is no option to select from the list...
|
| How to use MSExcel to plot Column A against Col B? | 31 Dec 2006 12:14 GMT | 8 |
I want to plot col A (x axis) against col B ( y axis). I cant seem to do it. Can anyone here please give me step by step primer. Thanks in advance. All I get is the graph of (1,2,............n) (x axis) against the n
|
| Drop Down list | 31 Dec 2006 01:33 GMT | 1 |
I've created a list of 10 names. Each name is in a different font and color. These 10 names make up the possible selections for a drop down list. When I select a name from the list and excel enters it into the cell, the font
|
| if(find..) problem | 31 Dec 2006 00:25 GMT | 4 |
I used a formula like =IF(FIND("TELUS",D234)>0,C234,0) this works fine as long as the word TELUS is in cell D234 but gives #value! error otherwise. I would have expected 0. What should I have done instead?
|
| Formula help | 30 Dec 2006 22:22 GMT | 10 |
I need a formula which can be copied to any row in a spreadsheet to produce a sum of the rows above startign at row 2. eg =SUM(G2:Gthisrow-1) I also need one to calculate the difference MIN & MAX in the same manner
|
| Strange copy / paste special -> Data Validation behaviour | 30 Dec 2006 20:38 GMT | 2 |
I am a fan of Data Validation, but tonight was disturbing. I use =IF($C7<>"",hours). This a valid statement and can be used for both "list" option as "custom". (hours = defined name of a range of values)
|
| sub to delete rows is very slow | 30 Dec 2006 20:37 GMT | 5 |
I have quite a long procedure that conditionally formats a worksheet. It calls a number of other procedures including the one below to delete rows. It works well for i=50 but beyond 500 is very slow. I need to check
|
| Error Messages | 30 Dec 2006 15:14 GMT | 2 |
After migrating my settings to my new computer from the old, I have an annoying dialog box which says, "Compile error in hidden module: AutoExecNew" when I open the program and another dialog box saying, "Compile error in hidden module: DistMon. What is the problem, and how do I ...
|
| Sheet protection help | 30 Dec 2006 12:28 GMT | 1 |
Pls adv why the Office 2000 SR-1 Small Business (Excel), can view the formula created by Office XP Small Business eventhough it is protected by password? However, when i sent the file to another workstation that is using Office XP Small Business, it could only edit the cells that ...
|
| Moving Macros from Personal.xls to "This Workbook" | 30 Dec 2006 08:24 GMT | 5 |
I created macros and stored them in Personal.xls and now want to move them to "This Workbook". How do I do that?
|
| How to collect unique rows only using formulas? | 30 Dec 2006 06:59 GMT | 8 |
Hi, is there any other ways of collecting unique data (anything, not just numbers) from a verti column and transpose it to hori row? example from
|