Home |
Search |
Today's Posts |
#1
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidate multiple worksheets | Excel Worksheet Functions | |||
How to consolidate multiple worksheets into one. | Excel Discussion (Misc queries) | |||
Consolidate different worksheets into one worksheet | Excel Discussion (Misc queries) | |||
How to consolidate data from multiple worksheets. | Excel Worksheet Functions | |||
VBA to consolidate multiple worksheets to 1 worksheet in running sequence | Excel Programming |