I'm switching from a PC to a Mac.  Where do I store personal.xls (where all
my macros are)?  I can't seem to find the XLStart folder...
Thanks!

In the below subprocedure I want to format Saskour20per with %.  This result
Saskour20per will be placed in different cells depending of some if
conditions, therefore I can't set a Range("A1") for example.
Saskour20per = (saskour20 / sask20)

I have a Calendar control for which I've set various size and position
numbers.  Each time I save the file, close and reopen, it reduces in size
until, finally I can't even read the numbers. I then need to stretch the
calendar back to a proper size.

Is it possible?  I have a Word document with repeating blocks of information
for which I would like to use merge fields to insert data from an Excel
spreadsheet.  Is there a way to merge multiple rows of info from Excel
(2007), each row's data merging sequentially into the info ...

I am trying to create a invoice/pull list for a warehouse in excel.  I need
to know if there is a way for me to put a item name in and it pull up
everthing that should be pulled for that item?
For example:

I need help creating an excel formula. I have a spreadsheet that calculates
employee paid time off based on years of employment, but there is a cap. So,
I need to create a formula that indicates that time off is accrued at a
specific rate, unless the time cap has been reached, in ...

Hello,
I have a column of dates in dd/mm/yyyy format, and I need to add up the
total number of instances in a given month.  I have been trying to use a
COUNTIF (P:P, (DATE mm = "01")) formula, and a million and one other

When I set "number of copies" to anything higher than 1, I still only get 1
copy.  I don't have this problem in Word 2007.  Anyone else encounter this?

I have an Excel sheet that has a Master Tab and then 5 other tabs that breaks
out the Master information by Region.  All spreadsheets have filters.  Is
there a way that if you select a certain vendor from a drop down on the
Master tab that all the other tabs would filter by that ...

I'm trying to format some cells so that:
- if cell value is between -5 and 5, it formats the font Green
- if cell value is between -6 and -20 or 6 and 20, it formats the font Yellow
- if cell value is between -21 and -100 or 21 and 100, it formats the font Red

I am a first time user of this discussion group, semi-technical and use Excel
2003.
I want to create an order form on worksheet 1 that would also create a
specific vendor purchase order on a separate worksheet.  In other words, I

Relatively new to Excel. Need to multiply the currency value in column A by
2. If sum is less than 0.50 round to 0.50 otherwise display sum in colum B.
Thank you, Jerry
PS: Would the latest version in Excel make it easier to write formulas

Is there a function that will calculate the amount a cell has changed.
For example the cell has a 2 in it and I change it to a 4. I'm looking for a
function that will show the difference as being 2.

I am working on a workbook thta contains 4 worksheets.  Each worksheet has
anywhere from 10-30 columns.  Each column contains a formula, some are quite
lenghty.  Most are calculations of some sort.  Most formulas reference 2
worksheets.  This is going to be used by others as a ...

Excel 2000
I must have something set wrong.  Three things may happen with this formula
in column C:
=IF(A1<>A2,A1,"")   - either the whole formula (including the =) appears in