I have a workbook named Small Workbook with 3 worksheets. Thos
worksheets named Sheet 1, Sheet 2, and Sheet 3.

All the worksheets have the same format, and are in the followin
manner:-

Column A = Date
Column B = Number
Column C = Particulars
Column D = Amount

I need to consolidate all the above Information into another workboo
called Big Workbook and it has only 1 worksheet named Sheet Bigger.

The Sheet Bigger is presented in the following manner.
Column A = Date
Column B = Number
Column C = Particulars
Column D = Amount from Sheet 1
Column E = Amount from Sheet 2
Column F = Amount from Sheet 3

I would like to know whether VBA can directly update data from Smal
Workbook to Sheet Bigger in Big workbook in a running sequence of date
Also, without any formula included in the Big workbook.

Illustration:
In Small Workbook
Sheet 1, Cell A2 = 1/1/2004, Cell B2=123456, Cell C2=BMW, Cell D
=$5.00
Sheet 2, Cell A2 = 4/1/2004, Cell B2=222222, Cell C2=PORCHA, Cell D
=$1.00
Sheet 3, Cell A2 = 2/1/2004, Cell B2=654321, Cell C2=A&W, Cell D
=$3.50

In Big Workbook
Cell A2 = 1/1/2004, Cell B2=123456, Cell C2=BMW, Cell D2 =$5.00
Cell A4= 4/1/2004, Cell B4=222222, Cell C4=PORCHA, Cell E4 =$1.00
Cell A3 = 2/1/2004, Cell B3=654321, Cell C3=A&W, Cell F3 =$3.50

For Big workbook sorting sequence based on DATE.

Please advice.

Thank u.


Susa

--
chongchingso
-----------------------------------------------------------------------
chongchingsoo's Profile: http://www.excelforum.com/member.php...fo&userid=1633
View this thread: http://www.excelforum.com/showthread.php?threadid=27735

hi,
do all of the file hav the same number of rows.
do the files contain duplicat data.

-----Original Message-----

I have a workbook named Small Workbook with 3 worksheets.
Those
worksheets named Sheet 1, Sheet 2, and Sheet 3.

All the worksheets have the same format, and are in the
following
manner:-

Column A = Date
Column B = Number
Column C = Particulars
Column D = Amount

I need to consolidate all the above Information into
another workbook
called Big Workbook and it has only 1 worksheet named
Sheet Bigger.

The Sheet Bigger is presented in the following manner.
Column A = Date
Column B = Number
Column C = Particulars
Column D = Amount from Sheet 1
Column E = Amount from Sheet 2
Column F = Amount from Sheet 3

I would like to know whether VBA can directly update data
from Small
Workbook to Sheet Bigger in Big workbook in a running
sequence of date.
Also, without any formula included in the Big workbook.

Illustration:
In Small Workbook
Sheet 1, Cell A2 = 1/1/2004, Cell B2=123456, Cell C2=BMW,
Cell D2
=$5.00
Sheet 2, Cell A2 = 4/1/2004, Cell B2=222222, Cell
C2=PORCHA, Cell D2
=$1.00
Sheet 3, Cell A2 = 2/1/2004, Cell B2=654321, Cell C2=A&W,
Cell D2
=$3.50

In Big Workbook
Cell A2 = 1/1/2004, Cell B2=123456, Cell C2=BMW, Cell D2
=$5.00
Cell A4= 4/1/2004, Cell B4=222222, Cell C4=PORCHA, Cell
E4 =$1.00
Cell A3 = 2/1/2004, Cell B3=654321, Cell C3=A&W, Cell F3
=$3.50

For Big workbook sorting sequence based on DATE.

Please advice.

Thank u.


Susan


--
chongchingsoo
----------------------------------------------------------
--------------
chongchingsoo's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=16338
View this thread:
http://www.excelforum.com/showthread...hreadid=277358

.