I want to put the following formula into a macro, what commands do
use? If Z1=1, goto A1, if z1=100 goto A100.
Can someone help please?
Thank you

I need help setting up a formula that will look at 2 values; x (being
P1(i), P1(ii), P2(i), P2(ii), P3(i), P4, P5, P6, P7, P8, L1C, L1B, L1A,
L2C, L2B, (I thought this would probably be in a column P Score). Then
look at the value y (which would determined whether the numerical ...

I have a two page worksheet. On the first page, data is entered into a 7
row by 6 column table.  Several computations are done on all the data
and a weekly report can be printed.  I want to accumulate that weekly
data in a list on the second page using a macro.  I have recorded a ...

I have a column of numbers, all multiples of 10, starting at 100 and going
up into the thousands. I want to round them to the nearest 50, so 140 would
become 150 and so would 160. How do I do that?
TIA

I've inherited a Excel 2003 .xls and the Page numbers appear in large font in
the background as I'm viewing/working on it.  [they don't print].
How do I suppress this?

...... using date function(s)?  
I have no problem converting a *date* to a quarter using the following formula.
=IF(ISBLANK(C1),"",INT((MONTH(C1)+2)/3))  where C1 = 1/1/2006.
A blank cell is month 1 because it is treated as 1/1/1900.  =month(C1) returns 1 when C1 is blank.  I think ...

Is there a formula to capture the current user's name (%username%) in a
cell?
I do not want to use any code that will ask the users to enable macro when
they open the document.

when i enter a number in a cell in  excel 2003 worksheet appear in the cell
as the number divide par 1000
e.g. I enter the number 1 in a cell
when I <ENTER>, in the cell appear 0,001

I read the following and have a couple of questions.

I have been using an Excel worksheet to track my time, etc for my job for a
few months. I normally send it to my employer by selecting File > Send To >
Mail Recipient and going from there.
Yesterday when I opened my worksheet, it had added several email fields

Right, I've had enough of this a.shole. It's time to expose this prick
so that he will cease and desist from his arrogant, self-righteous
ways. John Doe the a.shole's real name is Mark Bender.
Address:

Alrighty, not sure why this isn't working but I've only been reading up
on this lately.
What I need the code to do is to go through the range I2:I500 and if it
comes across a cell value, bring up a menu with the value two columns

Hi NG!
I just installed Office 2007. When I start Excel, it doesn't start with a
new (empty) workbook, which it did before (Excel 2003). This happens just on
my machine. Not on others. I found nothing in the options. Any idea?

I am working on a spreadsheet which uses gets information from an external
excel file.  Initially I was using VLOOKUP, which I have since changed to
INDEX(MATCH)).  Either way I get the same problem, which is the error message
in the subject.  The External excel file is approx ...

Usaing excel 2000, how do I get alternate coloured rows without having to
select and colour each one??
Tim