Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Macro to insert data into next blank row?09 Sep 2006 09:40 GMT2
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 GMT3
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 Colors09 Sep 2006 02:04 GMT1
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 numbers09 Sep 2006 01:53 GMT3
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 chang09 Sep 2006 01:38 GMT2
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 GMT1
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 Criterium09 Sep 2006 00:48 GMT5
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 worksheet08 Sep 2006 23:08 GMT2
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 Graphs08 Sep 2006 22:48 GMT1
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 lines08 Sep 2006 20:49 GMT3
I have large txt. data sheets as many as 3 to 400000 lines that i would like
to paste into multiple sheets
Excel VBA Help08 Sep 2006 20:13 GMT3
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 code08 Sep 2006 20:00 GMT4
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 interface08 Sep 2006 18:53 GMT2
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+e08 Sep 2006 18:20 GMT1
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 document08 Sep 2006 18:09 GMT1
Why does a 25 page Word Document appear to have 400+ pages when I copy it to
Excel?  Obvious slow down!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.