dear All expert
send for all my greeting
please kindly can someone help me in the attached file for the following
In my attached file you will find 3 sheet
1-export Listbox (data exported from Listbox2) and you will find command show userform Data in listbox1 will be from Database Column B
2-Generated Data sheet , that from Exported Data in fist sheet , this data
will be generate as the following
Each operator Have 11 Location and 1 or 2 or 3 run according to choice
meaning for example
We select operator HH1 and three run
meaning data will be as sheet (Generated Data)
if another Operator choice will repeat it as the same for operator according to number of run as in attached file with operator HH8
3-Database sheet Which Have location and operator and runs
my problem as the following
in listbox1 sometime is come clear , i don't know why ?i think the code not connect specifically to database sheet , i think it for active sheet
also
code for generate data is not working and i cant add checkbox to this code i found in internet
export code also not working , i just want to export all filled column in Generated data sheet to new workbook with name (print) but in folder named with date and time for the same directory of excel file present
also if want to give me error message if i didn't select any checkbox in Select type
and give me also error message if i didn't select run number
hope you can understand what i mean
if any thing not clear you can ask
regards for all and hope happy night
Bookmarks