i am working on a macro that will transfer the data from multiple workbook files with differents worksheets to one work book with 2 worksheet
Example
Like i have 3 workbooks as
(A)sales order with coulmn
(1.)orderno
(2.) orderdate
(3.)shipto
(B) shipment
(1.)shipmentdate
(2.)quantity
(3.)orderno
(C)third workbook delivery
(1.)deliveryboy
(2.)deliverydate
(3.)orderno
with only one sheet1 with information
and i want to send the data from these file with unique key validation to fourth file called tracker
which has two sheets
1. shipment having coulmn like shipto , deliverydate , deliveryboy , quantity ,orderno not in orderly manner manner
2. ordering having coulmns orderno , orderdate , orderno
and according to name of the coulmn
i have just started vba .Please some body help me out.i am beginner in this . just know beginner stuff.
Example
Like i have 3 workbooks as
(A)sales order with coulmn
(1.)orderno
(2.) orderdate
(3.)shipto
(B) shipment
(1.)shipmentdate
(2.)quantity
(3.)orderno
(C)third workbook delivery
(1.)deliveryboy
(2.)deliverydate
(3.)orderno
with only one sheet1 with information
and i want to send the data from these file with unique key validation to fourth file called tracker
which has two sheets
1. shipment having coulmn like shipto , deliverydate , deliveryboy , quantity ,orderno not in orderly manner manner
2. ordering having coulmns orderno , orderdate , orderno
and according to name of the coulmn
i have just started vba .Please some body help me out.i am beginner in this . just know beginner stuff.
