View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

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.