Hi,
I want to create different workbook from one criteria. For ex:
Column A column B
1. Tool
1. Gear
2. Parts
2. Shades
So here I want that if column A has 1, it will create a workbook with name 1 and shift all the rows with 1 in column A to the new workbook. Likewise for 2.
Please help.
I want to create different workbook from one criteria. For ex:
Column A column B
1. Tool
1. Gear
2. Parts
2. Shades
So here I want that if column A has 1, it will create a workbook with name 1 and shift all the rows with 1 in column A to the new workbook. Likewise for 2.
Please help.