Mac Forum / Applications / Excel / September 2007

How to I create a lookup table (in the worksheet) and use the =lookup
function for a letter grade based on the quiz average with these rules:
An average below 60, the grade is a F.
An average of 60 or more but below 65, the grade is a D.

One week ago this function stopped returning values for preferred shares. Has
something changed.

Currently in a macro, I copy a cell from Workbook A into Workbook B by
specifying the worksheet and cell ID.
The cell is named.  I have tried using the cell name but it's not working.

The date problem in EXCEL for MAC seems to appear when files created on a
MAC are viewed on a PC !

I have a sales forecast spreadsheet for each sales person in the company.  
Their Targets are all linked into a main workbook which brings everyone's
results together.  
Their results sheet is linked to the main workbook and password protected so

Is there a way to have a spreadsheet update stock quotes automatically
or have it done when I refresh the screen? I know this can be
accomplished in thw windows version. Thank you.

I added a digital signature to a worksheet so that the macros would work but
the office 2007 program is telling me that the signature is not valid. How
can I fix it? The same signature works on another computer at my office.

Everytime I start my Macbook Pro Excel starts up too. It's driving me
nuts. How do I disable automatic start up??

I am looking for a conditional formula, please attached document.
The YTD  sheet is  referencing data from the Quarter sheet, the Quarter
sheet is referencing  data from the Monthly, if  any sheet's value is 0 I do
not want that sheet referenced in the results, Is there a formula ...

I've a spreadsheet created by someone else where the individual has
inexplicably stuck an asterisk in front of entries in some fields. I
initially thought this was a no brainer, that a simple find and
replace all would do the trick, but apparently Excel treats the

i need to know how to insert a command button into a word document so
when you click it, it runs the program.  THANKS!

I have a PC-based version of an Excel file which contains VBA.
Whenever I open it on a PC, I have to ensure the Macro security
settings are Medium or Low, so that the VBA works.
When a friend of mine goes to open the file on her Mac, she advises

Hi all, Using xl 2004 v.11.3.5 - Mac OS 10.4.10
I am trying to run solver from a macro but not having much luck.
If I select solver from the menu and input the right info and click solve
It works fine. When I run solver via a macro I get a compile error - Sub or

First let me tell you what I want to accomplish.
I am creating a form that, when used, a part will perferated and stay
in one department (parts) and the rest will stay with the originator.
The parts department will then return that portion of the form with

Hi,
I need help converting a column of numbers to a date format.
Example: 19991120  need to convert to 11/20/1999
Please help!