without any doubt excel is a great help to Accountants. I do a lot work on
excel. Even once I maintain company account for a year in 2000 and 2001.
Now my question is that how I can lock more than one range (Row & Coloumn)
in a worksheet.

add the value to a date in 1st worksheet to the value in the date in the new
work sheet.
using a macro function
I would like to add a new worksheet and use the date value in the previous

Creating Nested Functions using IF AND and IF OR
Help Please. Its for an assignment and I just can't get it.
The problem is as followed:
5 days for Full time employees who have worked 1 or more years.

Can i count how many letters A from cell e10 to sell h10  ?
i need to count all value countin letter a .
I have attendence sheet and I alwayes put letter p for present student and
letter a for student who is absent .  So in the total list of absenties i

I've got quite  a complicated workbook, and have entered test data to check
it. I now want to delete the test data, but not the various formulae. I think
I read somewhere in a magazine that this was possible, but can't now find
how. Any thoughts gratefully received.

Please help! I have a range of values between 1 and 20 as follows:
18 3 15 9 2 4 11 5 13 16 20 1 14 3 8 17 11
How do I use Excel/Visual Basic to determine a single optimum value in the
range?

In Excel sheet I want total of the month after 30 days of data, date wise.
This sheet contains data of about 8 years date wise.

In the cells c20 to c30 I might have, or might have not some (text) data.
In the adjacent cells d20 to d30 I have a formula showing me some results.
I want that the formula results in cells d20 to d30 to be displayed only if
there is  data in the nearby correspondents "c" cells

2003 Excell - I'm asking a customer what they need, expected responses are in
column "B". Column A is a small box to be "X" 'd alongside the need they
express (column "B"). I want my "features and benefits" from another sheet to
automaticly paste to this sheet when I've placed an ...

I have a pivot table set up, reporting on a data table made up of almost
12,000 rows of data. The pivot table has been working fine.
Today I added more data to the data table, now bringing it to 11,990 rows.
However, my Pivot table does pick up data below row 11,923.

Have a sheet with Column A showing customer ID and column B showing Date
of transaction and column C showing Transaction amount.  I would like to
use a formula to find the most recent transaction date and transaction
amount for a customer Id that is entered into a cell on another ...

A     B        C                D
04    Brown    40987321        04bro*0987321
05    Smith    40983476        05smi*0983476
For security reasons I need to concatenate columns A & B & C to equal Column

"Ctrl + '      Insert the value of the above cell into cell currently
                selected."
The above keyboard shortcut no longer works. Changed KB, but no help.

I'm trying to setup an automated way to send computed bills to a list of
people in an organization (about 300).
We collect data (water usage) and use Excel to compute the bill based on
usage (current reading - previous times rate).

I have a sheet that looks like
User#    1/10/2007    1/17/2007    1/21/2007
1    0    21    44
2    0    45    66