Excel With User Forms

[zackefron]

Hello Buddies I am just working on some multiple projects stuck up with one of my file. I am making one file contains 2 User form named (Creation & Updation) with 1000 or may be more then that sheets in it.

In Creation User form I needed input boxes:

1. Sheet Number to create : 1
2. Sheet Created By: Zack
3. Received from : Zackefron
4. Received On: 04-Feb-2016
5. Reason: Operational
6. Flight Date: 25-Oct-16 Till 31-Oct-16
7. FLT No.: BA-196
8. Sector: AMS-NYC
9. STD-STA: 1000-1500
10. RTD-RTA: 1600-2100
11. Days Eff.: ALL
12. Remarks: Timing Change

Note: If 2, 3, 4,5,7,8,9,12 left bank then also work.

Output Needed in Sheet 1:

01.JPG

If in Days Eff.: I put 2,3,4,6 with all the details provide above.
Then the Output Needed in Sheet 1:

02.JPG

D.Ops column is contain the day no.
Monday – 1
Tuesday – 2
Wednesday – 3
Thursday – 4
Friday – 5
Saturday – 6
Sunday – 7

In Updation User form I needed input boxes:

1. Sheet No. To Update: 1
2. Dates To Update: 25-Oct-16 Till 27-Oct-16
3. Action By: James
4. Time: 1800 Hrs
5. A.Date: 08-Feb-16
6. Out dialer: HT

Output Needed in Sheet 1:

03.JPG

*Note: Inf. Gap columns having the value (A.Date-Flight Date)
As I am already engaged with various projects I am totally blanked in this project. Please if anyone can help on this I will be very grateful. If possible help me with excel sheet.

[LeoTaxi]

this is a help forum
not a make for me forum

Kind regards
Leo

[zackefron]

I know buddy but i am stucked very badly if possible please help.

[LeoTaxi]

help ok, but first give us a file to work on.


Kind regards
Leo