if i have some & similar data (same format - eg. date wise sales sheets in a
file) in different worksheets of an EXCEL workbook (eg. A1..Z100 in Sheet1
for Ist day of the month, A1..Z100 in Sheet2 for the 2nd day of the month,
A1..Z100 in Sheet3 for the 3rd day of the month, ......& so on - soforth for
a complete month (Sales data except of Saturdays & Sundays).....

How do i copy the Sales data from all the Sheets of the workbook to the
Sheet32 ?
The sales data shd be copied in the following format (preferaably automated
- PLS. DO NOT SUGGEST : Select / copy & paste).

Sheet32
A1..Z100 - Sales data from Sheet1. (First day sales)
A101..Z200 - Sales data from Sheet2. (2nd day sales)
A201..Z300 - Sales data from Sheet3. (3rd day sales)
..
..
..
The data from each sheet should be copied to Sheet32 at the end of the Sales
data copied from the previous sheet in vertical manner.
The objective is to consolidate a months data.
(This is like concatenation, but of an array - similar to the adding of the
records in a database thru an ERP / GUI.)

PLS. SUGGEST / HELP.

One way ..

Assuming 31 source sheets named as: Sheet1, Sheet2, ... Sheet31, with data
in A1:Z100 in each sheet to be extracted over and placed sequentially one
below the other

In Sheet32
-------------
Put in A1:

=OFFSET(INDIRECT("Sheet"&INT((ROWS($A$1:A1)-1)/100)+1&"!$A$1"),MOD(ROWS($A$1
:A1)-1,100),COLUMNS($A$1:A1)-1)

Copy A1 across to Z1, fill down to Z3100
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"sansk_23" wrote in message
...
if i have some & similar data (same format - eg. date wise sales sheets in
a
file) in different worksheets of an EXCEL workbook (eg. A1..Z100 in Sheet1
for Ist day of the month, A1..Z100 in Sheet2 for the 2nd day of the month,
A1..Z100 in Sheet3 for the 3rd day of the month, ......& so on - soforth
for
a complete month (Sales data except of Saturdays & Sundays).....

How do i copy the Sales data from all the Sheets of the workbook to the
Sheet32 ?
The sales data shd be copied in the following format (preferaably
automated
- PLS. DO NOT SUGGEST : Select / copy & paste).

Sheet32
A1..Z100 - Sales data from Sheet1. (First day sales)
A101..Z200 - Sales data from Sheet2. (2nd day sales)
A201..Z300 - Sales data from Sheet3. (3rd day sales)
.
.
.
The data from each sheet should be copied to Sheet32 at the end of the
Sales
data copied from the previous sheet in vertical manner.
The objective is to consolidate a months data.
(This is like concatenation, but of an array - similar to the adding of
the
records in a database thru an ERP / GUI.)

PLS. SUGGEST / HELP.

Look at http://www.rondebruin.nl/copy2.htm I found it very useful.

"Max" wrote:

One way ..

Assuming 31 source sheets named as: Sheet1, Sheet2, ... Sheet31, with data
in A1:Z100 in each sheet to be extracted over and placed sequentially one
below the other

In Sheet32
-------------
Put in A1:

=OFFSET(INDIRECT("Sheet"&INT((ROWS($A$1:A1)-1)/100)+1&"!$A$1"),MOD(ROWS($A$1
:A1)-1,100),COLUMNS($A$1:A1)-1)

Copy A1 across to Z1, fill down to Z3100
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"sansk_23" wrote in message
...
if i have some & similar data (same format - eg. date wise sales sheets in
a
file) in different worksheets of an EXCEL workbook (eg. A1..Z100 in Sheet1
for Ist day of the month, A1..Z100 in Sheet2 for the 2nd day of the month,
A1..Z100 in Sheet3 for the 3rd day of the month, ......& so on - soforth
for
a complete month (Sales data except of Saturdays & Sundays).....

How do i copy the Sales data from all the Sheets of the workbook to the
Sheet32 ?
The sales data shd be copied in the following format (preferaably
automated
- PLS. DO NOT SUGGEST : Select / copy & paste).

Sheet32
A1..Z100 - Sales data from Sheet1. (First day sales)
A101..Z200 - Sales data from Sheet2. (2nd day sales)
A201..Z300 - Sales data from Sheet3. (3rd day sales)
.
.
.
The data from each sheet should be copied to Sheet32 at the end of the
Sales
data copied from the previous sheet in vertical manner.
The objective is to consolidate a months data.
(This is like concatenation, but of an array - similar to the adding of
the
records in a database thru an ERP / GUI.)

PLS. SUGGEST / HELP.

And I'll betcha you can complete the suggested formula approach and get it
up and running even before Ron's page loads completely <bg ! (Just
kidding). One is seldom bereft of choices in these excel newsgroups.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----