NoMenClature
New Member
- Joined
- May 14, 2019
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Good day,
I'm looking to extract all rows of unique values for a giving column (col L), directly to separate workbooks (Wb's); not as sheets in the active Wb.
The examples I've seen haven't account for these in one sub:
- exports based on unique values in column (e.g. 18 unique values = 18 separate Wb's)
- copy entire rows, including header & header format
- name exported Wb's as the unique value from column (col L)
- save Wb's to same folder as current Wb extracted from
- ideally all columns of Wb's are auto fitted (but not necessary)
*The sheet/tab extracted from (named "Reqn ID") could have 0, 1, or thousands of lines of data
I'm looking to extract all rows of unique values for a giving column (col L), directly to separate workbooks (Wb's); not as sheets in the active Wb.
The examples I've seen haven't account for these in one sub:
- exports based on unique values in column (e.g. 18 unique values = 18 separate Wb's)
- copy entire rows, including header & header format
- name exported Wb's as the unique value from column (col L)
- save Wb's to same folder as current Wb extracted from
- ideally all columns of Wb's are auto fitted (but not necessary)
*The sheet/tab extracted from (named "Reqn ID") could have 0, 1, or thousands of lines of data
