i have a a Workbook that contains multiple sheets with Diff data, but having
the same Column & Rows. How do i consolidate all the data from these diff
sheets to make one report.
i hope my question is clear

this sounds like using excel as a data recording tool question.
i have a client asking me this:
1. when he creates a new order either in word doc. (which he prefers
or in excel (he can accept using this too), how can I help him ente

I have 2 spreadsheets. 1 is  a list of procedures. This list has the
columns id_code, name, date_procedure
The other is a list of test results with the columns id_code,
date_test,result.

entry date               exit date                        $$ invested
01/01                 01/05                                 1200
01/03                 01/06                                 1254
01/04                 01/09                                  654

I have a worksheet with 2 columns of data (non-numeric), I need to count the
occurences of each row in column 2 in column 1.  The data in column 2 appears
once and in column one it may appear 1-many times. eg data is like this,
(column 3 is the requested count of column 2 in ...

Excel 2000
Really simple data sheet: list of names with homerooms
Lookup table: list of homerooms with teachers. (named "Range")
=VLOOKUP(E2,Range,2)

I don't know how to do this and keep it short. I have created an excel
workbook to do tournament events and the entire process is now automated
except for changing the start times of the events. I need a formula or custom
function that does 3 arguments. The one I created ...

I'm in the process of transitioning my work office from filing cabinets
full of paper and piles of ledger books to doing everything on the PC.
I am currently keeping records on paper to record the ACTUAL negatives
but not add them to the total.  Once I can make Excell record the

Is there a way I can easily change the year in a list of randon dates?
I have a table in excel, with date in the first column.  I need to b
able to change the year of the date, without changing the day an
month.

How do I make an invoice that has two pages and let the total carry over to
the second page. Thanks, Bruce

I am trying to import data from a workbook created by our IS team into
my workbook which calculates the sales bonus of my employees.
Currently, I manually enter their sales numbers.  The problem is I am
duplicating efforts because the IS workbook already has the numbers I

I am using a spreadsheet that was developed by a prior worker and I'm having
trouble sorting the product using one of the fields without it changing the
values in the other fields. I.E column 3 has been assigned a ranking number
based on its importance to our workforce. Column 6 ...

Hi, I am using macro to display below password input box:
--------------------------------------------------------------------------
Sub open()
myPWD = Application.InputBox("Password Protected! Please Enter Authorized

Can anyone tell me the formula for rounding a column of currency up to the
nearest nickel? Thanks

I am trying to import data from a workbook created by our IS team into
my workbook which calculates the sales bonus of my employees.
Currently, I manually enter their sales numbers.  The problem is I am
duplicating efforts because the IS workbook already has the numbers I