I have a Form on one sheet and a summary on the next sheet.
What i want to do is be able to type in text on the form and have it
automatically transfered to the summary e.g. date, description, amounts etc.
Can anyone help??

I am trying to calculate employees pay with overtime starting after 40
hours per week.
Below is an example for two employees over the two week pay period:
    Date In    Time In    Date Out    Time Out    Total Time

Is it possible to have worksheets scroll at the same time? For example when
you scroll down to line 100 on sheet 1  and then you go to sheet 2 or 3 or 4
and that sheet will be on line 100 also?

Does anyone have any suggestions on how to do the following?
I have 2 columns, one for months and the other for a number value.
I use the Max function to find the largest number in the second column,
which is 9 here.

Is it possible to average up to certain row indicated in "Last number to
average" or C8
A    B                                          C  
1    5

I have a large named range (80 columns, 120 rows).  Vlookup hangs (processor
pegged at 100%) now that I have created it.  Would speed improve if I split
this large range into multiple smaller ones?  I am keeping all vlookups
within the same worksheet based on advice from an older ...

Please can someone help/advise, I would like the result of the conditional
formatting affect other cell or cells other than the one where the condition
is typed.
Many thanks

Trying to filter a sheet for all "Pending" in a column and move to another
sheet. The "Pending" is made by a Validation drop-down box. It says "You can
only copy filtered data to another sheet. If I don't try to move it, it works
fine. (AutoFilter or Advanced) Help!!

I'm using a pivot table to compare sales data from 2004 to 2005 on a weekly
basis for several items and locations.  (Location and Items are in rows,
weeks and years are in columns).  By default it added a sum of the sales for
2004 and 2005 for each week.  I would like to see the ...

I need to create a formula that will compare the contents of cells
A2:A2000, to the contents of cells A2:A2000 in another worksheet
('schools'), and when finding 2 values that match, I need to bring the
contents of the corresponding cell in column B from 'schools' into the

I have a lookup formula and I want to do two things with it.
Formula =LOOKUP(C251,Data!B:B,Data!A:A)
When cell C251 is blank it currently returns #N/A, I would like to return a
blank cell.

I need to compute the avg of all 100 iteraions.  I set the iterations in the
Tool->options->calculation->iteration.  Now i need to compute the avg of all
100 iterations. Any help would be greatly appreciatted.
Thanks,

I am using a time card template and what i want is a forumal that if i put 10
hours in the reg hours colum it will automatically change and add the 2 hours
of overtime in the overtime row is this possible?

I am working with a spreadsheet that contains whole hour times for Regular,
Over, Sick and Vacation times.  When 9 is placed in Regular time, I want the
number to remain at the max number of 8 hours Regular time, moving the 1 hour
Over time into the next cell.

I am looking for a formula or a way to have years & months calculated from a
starting month and year.  Here is what I have.  
Sheet 1 has 2 cells, cell A1 is for picking the starting month (from a drop
down list)  &  cell A2 is to pick the starting year (also from a drop down