Dear Sir
i would like to create macro that will do the following action:
1- macro to create folder with specific name (this name will be present in Column A for Example ) and if this folder is present give me message that the folder is present .

this example as the follow

Column A1 have product name : XYT
the macro will create folder with name XYT

another macro that make same action but with subfolder creation and file
2- macro to create folder with specific name (this name will be present in Column A for Example ) when i enter data in Column A and if this folder is present give me message that the folder is present then create subfolder inside this folder created before (which related to product ) with specific name Present in Column E for example when i enter any data in Column E then will copy one sheet (specific name for example Sheet1) and put in the subfolder


This example as the follow

column A1 have product name : ZSG and Column E1 have B#152214
this will create folder with name ZSG then Subfolder with name B#152214 and if in any other Cell in column A have the same product but in E contain other number For Example B#152615 will not create ZSG folder but will create subfolder with B#152615 name
then copy sheet1 an put in this subfolder

hope my explanation is clear