Hello,
I am new to excel and vba but trying my best to learn to ease my job I am also new to forum and this is my first thread.
I want to add an interface to enter serial number, type and start date data to a new worksheet. There are 2 different worksheets for different types (PW Time Table and PC Time Table). There are several processes in each worksheet and i want to add all processes to that interface and make them selectable. And i want macro to choose correct spreadsheet, copy necessary rows to this worksheet starting from the date we entered as ''start date''.I also want to add work order. If i add 4 entries, it should start two of them from the date entered as ''work start'', and delay other two work's date till first two work ends. And it should also exclude weekends. I have added sample of June.
Normally i have been doing this manually and it's time consuming. Hoping someone can help me out, or give me some guidance about how this can be done.
Bookmarks