The treasurer of a local non-profit organization sends me a workbook
each month containing worksheets for each bank deposit. I want to put
all of the data into one Excel 2000 worksheet to use for monthly
membership mailings.

Each worksheet contains three sections: header, data, sums. The header
looks like this:
------------------------------------

MY NON-PROFIT ORGANIZATION NAME
INCOME FOR JULY 2005
DEPOSIT DATE: 7/13/05
FIRST_NAME LAST_NAME STREET/CITY/STATE/ZIP GIFT M'SHIP TOTAL

---------------------------------------
The data rows are as you might expect:

***************************
firstname1 lastname1 street/city1 gift_amt1 m'ship_amt1 total1
firstname2 lastname2 street/city2 gift_amt2 m'ship_amt2 total2
etc.
***************************
Each worksheet may have a different number of data rows.

The 'sums' row contains formulas like =SUM(M5:M40) for some of the
columns.

How can I end up with one worksheet containing all data for the month?
i.e.:

HEADER
data for week 1
data for week 2
data for week 3
data for week 4

I don't really care about the 'sums' data.

Thanks so much,
Teffy

Hi Teffy

Try this
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Teffy" wrote in message ups.com...
The treasurer of a local non-profit organization sends me a workbook
each month containing worksheets for each bank deposit. I want to put
all of the data into one Excel 2000 worksheet to use for monthly
membership mailings.

Each worksheet contains three sections: header, data, sums. The header
looks like this:
------------------------------------

MY NON-PROFIT ORGANIZATION NAME
INCOME FOR JULY 2005
DEPOSIT DATE: 7/13/05
FIRST_NAME LAST_NAME STREET/CITY/STATE/ZIP GIFT M'SHIP TOTAL

---------------------------------------
The data rows are as you might expect:

***************************
firstname1 lastname1 street/city1 gift_amt1 m'ship_amt1 total1
firstname2 lastname2 street/city2 gift_amt2 m'ship_amt2 total2
etc.
***************************
Each worksheet may have a different number of data rows.

The 'sums' row contains formulas like =SUM(M5:M40) for some of the
columns.

How can I end up with one worksheet containing all data for the month?
i.e.:

HEADER
data for week 1
data for week 2
data for week 3
data for week 4

I don't really care about the 'sums' data.

Thanks so much,
Teffy

Dear Ron de Bruin,

I am very grateful to you for your instructions! Now I am able to do
exactly what I wanted! And, you have given me the start I needed to
record a macro; adding even more to the capability!

Thank you so much.
Teffy

You are welcome

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Teffy" wrote in message oups.com...
Dear Ron de Bruin,

I am very grateful to you for your instructions! Now I am able to do
exactly what I wanted! And, you have given me the start I needed to
record a macro; adding even more to the capability!

Thank you so much.
Teffy