This is my first time posting in this forum. I got thousands of line item need to separate to new workbook. Is there any macro/VBA allow me to do so? Based on attached excel file, I only required to separate each criteria in column A to new workbook. Any helps is really appreciated. Still novice in Excel.
Bookmarks