Hi all
I want to extract two sheets from this sheet
I have made the sample sheets format as SECH & CCPORTAL
1: In SECH sheet should generate with the name of SECH and code should like if add some equip ID in code that also add similarly for that number if I delete that should not occur & save in 97,2003 formats with the workbook name SECH 1, 2 so on, should each sheet contain 190(changeable in code) numbers. column C & D will be static/constant and column A info will be extracted from CONT sheet & column B (Equip code) will mention in code manually (can be more as per my need)
2: & same things for CCportal sheet but this sheet should save in CSV format it should also contain data 190(editable in code as per need), in sheet info column B to E will take from CONT sheet & column A info will constant,
3: Main sheet(CONT) also extracted from with total 190(editable in code) and save in folder with name of UPD1,2,3 and so on in format 97-2003.
I have a folder in my desktop with the name of Master Activation, code should create another folder in it auto with today’s date activation..!(if I will run code(with different data) in same day second or third time sheets will save respectively in same folder) and new folder for next day.!
Code also remove all leading and trailing spaces and extra spaces between word if found any..!
If some column has special character like %^&* (specially in column S,X,W,Y)in data and more than 50 characters in cell code shows error (with error display)
Remove dashes (-) in columns N,O,P if found any
Thanks for your anticipation
Nabeel
I want to extract two sheets from this sheet
I have made the sample sheets format as SECH & CCPORTAL
1: In SECH sheet should generate with the name of SECH and code should like if add some equip ID in code that also add similarly for that number if I delete that should not occur & save in 97,2003 formats with the workbook name SECH 1, 2 so on, should each sheet contain 190(changeable in code) numbers. column C & D will be static/constant and column A info will be extracted from CONT sheet & column B (Equip code) will mention in code manually (can be more as per my need)
2: & same things for CCportal sheet but this sheet should save in CSV format it should also contain data 190(editable in code as per need), in sheet info column B to E will take from CONT sheet & column A info will constant,
3: Main sheet(CONT) also extracted from with total 190(editable in code) and save in folder with name of UPD1,2,3 and so on in format 97-2003.
I have a folder in my desktop with the name of Master Activation, code should create another folder in it auto with today’s date activation..!(if I will run code(with different data) in same day second or third time sheets will save respectively in same folder) and new folder for next day.!
Code also remove all leading and trailing spaces and extra spaces between word if found any..!
If some column has special character like %^&* (specially in column S,X,W,Y)in data and more than 50 characters in cell code shows error (with error display)
Remove dashes (-) in columns N,O,P if found any
Thanks for your anticipation
Nabeel