Hi guys,

I hope you can help me with my new project.

I've attached here a file of my new project. It's a data entry for the delivery and the order and generating report.

as my previous post in here, http://www.excelforum.com/excel-prog...-userform.html i am hard coding the data from my userform to my sheet. however a member in this forum introduce me to the loop.

1. can you help me loop this one, it's 5 items in a column and a blank cell next and another 5 items and so on.
2. importing previous data by delivery number / po number for editing using userform

3. generating report (i've made an example in the report sheet) so it will be accumulated balance from date to date...

I'm still working on the code for the dates to dates. right now, i'm focusing on the data entry.



New sample.xlsm