VISHAL120
09-09-2011, 04:13 AM
Hi ,
I needed help to automate this report if possible. Right now this is done manually this take enormous time. Thanks to see attached file for better idea.
I have a main order Book where everyday or week we add new order to process and to ship.
And based on this we actually need to give our production dept and shipping dept list of orders to be exported by week and delivery.
What I doing actually are:
Make a sorting by delivery then by customer.
Copy the standard header format for shipping.
copy the order by delivery and by customer from the main order book and paste on the reports to make the shipping schedules.
make a total for each customer on the bottom ( please see the attached file)
and repeat for every customer.
the report shall be separated for each customer and by delivery and every time there need to place the standard header format and sometimes there are other standard format header that shall be used for specific customer. See example.
I would be grateful if I can get some hint and help on how I can do this with vba.
Thanks and regards,
I needed help to automate this report if possible. Right now this is done manually this take enormous time. Thanks to see attached file for better idea.
I have a main order Book where everyday or week we add new order to process and to ship.
And based on this we actually need to give our production dept and shipping dept list of orders to be exported by week and delivery.
What I doing actually are:
Make a sorting by delivery then by customer.
Copy the standard header format for shipping.
copy the order by delivery and by customer from the main order book and paste on the reports to make the shipping schedules.
make a total for each customer on the bottom ( please see the attached file)
and repeat for every customer.
the report shall be separated for each customer and by delivery and every time there need to place the standard header format and sometimes there are other standard format header that shall be used for specific customer. See example.
I would be grateful if I can get some hint and help on how I can do this with vba.
Thanks and regards,