acerlaptop
New Member
- Joined
- Feb 17, 2020
- Messages
- 44
- Office Version
- 2013
- Platform
- Windows
Hi Guys,
Criteria = all range ("H2:H" & LastRow) has values (nothing is blank).
Inclusions = all worksheet except worksheet("Summary")
What will happen:
All this should only happen once there is a worksheet that meets the criteria.
1st Step = Move sheet that meets the criteria to a new workbook
2nd Step = Save the new workbook to a folder (folder name same with worksheet name) - if folder does not exist, then create - folder should be in same directory as the file
3rd Step = There are other folders in that same directory which has their first 4 letters same to the new folder. Move them to the new folder.
Hope someone can help me.
Thanks in advance
Criteria = all range ("H2:H" & LastRow) has values (nothing is blank).
Inclusions = all worksheet except worksheet("Summary")
What will happen:
All this should only happen once there is a worksheet that meets the criteria.
1st Step = Move sheet that meets the criteria to a new workbook
2nd Step = Save the new workbook to a folder (folder name same with worksheet name) - if folder does not exist, then create - folder should be in same directory as the file
3rd Step = There are other folders in that same directory which has their first 4 letters same to the new folder. Move them to the new folder.
Hope someone can help me.
Thanks in advance
Last edited: