message2sagar
New Member
- Joined
- Aug 27, 2020
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hi,
Am pretty new to macros and i would need a macro to split workbook into different tabs based on unique field/column, however my problem is i have first few rows which are headers in the main tab.
my request is
1. the first few rows to be copied in all the tabs while splitting the main tab as those headers will be same for all the workbooks
2. Macro should not filter on row1 instead it should filter on row 8 and take unique based on column F
is this possible to do so. Please help
Am pretty new to macros and i would need a macro to split workbook into different tabs based on unique field/column, however my problem is i have first few rows which are headers in the main tab.
my request is
1. the first few rows to be copied in all the tabs while splitting the main tab as those headers will be same for all the workbooks
2. Macro should not filter on row1 instead it should filter on row 8 and take unique based on column F
is this possible to do so. Please help