| Thread | Last Post | Replies |
|
| Macro to insert data into next blank row? | 09 Sep 2006 09:40 GMT | 2 |
I have a list of names, addresses, etc that I'm setting up for a mail merge. I already have a macro that converts the names from a format like this: Col A Name
|
| how do I figure a 15% projected increase of current quotas? | 09 Sep 2006 05:57 GMT | 3 |
I have entered a formula which figures a 10% projected increase in current quotas. Now I am supposed to change it to a 15% projected increase. I thought if I just changed the number from 1.1 to 1.15 I could get the new numbers, but it didn't work.
|
| A Problem with Fill Colors | 09 Sep 2006 02:04 GMT | 1 |
We have a user who needs to fill various cells with a different colors. When ever the file is opened, the colors change and she needs to reset them to conform to a predetermined Legend. What could possibly make the colors change? I am at a loss to explain this
|
| cell format problems - losing leading zeros in numbers | 09 Sep 2006 01:53 GMT | 3 |
Using Excel 2002. I am having trouble finding the right cell format to paste a number into that I get off of normal html web page. The problem is that I lose the leading zeros
|
| how to update data displayed from a UDF when the source data chang | 09 Sep 2006 01:38 GMT | 2 |
I have a workbook that I am trying to use a user defined function to always reference the previous sheet so I can make several copies of the sheet to cover a 52 week period. I have made it this far. However when I change the data and then go to the next sheet the calculations ...
|
| How do I make my top margins bigger? | 09 Sep 2006 00:50 GMT | 1 |
I am doing a spread sheet for work and want to make my top margins bigger, so I can add wording in them. Help!
|
| CountIF function with two Criterium | 09 Sep 2006 00:48 GMT | 5 |
Is there anyway to make create a COUNTIF function with two different criterium (i.e. >100 and <=499.99, etc)? If not, can someone direct me to a function that can assist me in counting cells that have data with two or more criterium?
|
| default save directory for a templated worksheet | 08 Sep 2006 23:08 GMT | 2 |
Is there any easy way to automatically have a template save to a particular location for that template only? e.g the 'Quotes' template saves to the quote directory the Orders template saves to the orders directory
|
| Floating Graphs | 08 Sep 2006 22:48 GMT | 1 |
Is it possible in Excel, to have a chart "floating" on a sheet, ie. as I scroll across or up and down the data on the sheet, to have the chart remain in the same place on the screen. Thanks,
|
| pasting beyond 64000 lines | 08 Sep 2006 20:49 GMT | 3 |
I have large txt. data sheets as many as 3 to 400000 lines that i would like to paste into multiple sheets
|
| Excel VBA Help | 08 Sep 2006 20:13 GMT | 3 |
I'm really confused. I thought the following code would work but it isn't doing what I expected. I have several data files that are exactly the same and I need to reformat all of them... Instead of opening each one and doing the formatting needed, I thought it would be nice to ...
|
| Copying code | 08 Sep 2006 20:00 GMT | 4 |
New to VBA so ... I have copied some of the great code from CPearson.com. If I open a new workbook and add the code to a new module. it works for that workbook (only). What I want to do is add it to personal.xls so it works in all workbooks. I
|
| Using english function names Excel with German user interface | 08 Sep 2006 18:53 GMT | 2 |
For some stupid reason, MS decided that a (e.g.) German version of Excel should not only have a German user interface (Menus, Online-Manuals/Help), but German function names as well. As I am used to use english function names, I am lost...
|
| Ask Excel not to change cell format to auto wrap after using alt+e | 08 Sep 2006 18:20 GMT | 1 |
Everybody knows that when you've a line return (inserted using ALT+ENTER) in a cell, Excel will change the cell format to "wrap" and adjust line height consequently. Now I would like to find a way to prevent Excel from reformating the cell
|
| Copy of Word document | 08 Sep 2006 18:09 GMT | 1 |
Why does a 25 page Word Document appear to have 400+ pages when I copy it to Excel? Obvious slow down!
|