Posted to microsoft.public.excel.programming
|
|
VBA to consolidate multiple worksheets to 1 worksheet in running sequence
Hello, :)
3 worksheets in Small workbook have difference rows.
Some of the data in Column A = Date and Column C = Particulars ar
duplicate in nature.
;)
Susan
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
.
--
chongchingso
-----------------------------------------------------------------------
chongchingsoo's Profile: http://www.excelforum.com/member.php...fo&userid=1633
View this thread: http://www.excelforum.com/showthread.php?threadid=27735
|