Goalexcel
Board Regular
- Joined
- Dec 28, 2020
- Messages
- 101
- Office Version
- 2016
- Platform
- Windows
Hello Expert Group for your excellent assistance.
I would like to ask for your kindly help in this task.
Step 1:
When select Column A= count 11 or 16 rows, (will never exact count amount to group Column A), and will assign a number in column B, creating a group.
I have to create 8 sheets with different number column A & B, never the same amount of sheets
I am doing manually, I am looking for a VBA code to automate the process.
I found conditional formatting but take time from 1 to 99 colors , every week change the excel files with new data.
The second step2 : All sheet1 until sheet8. Never will be the same sheets. Need to copy in one new sheet. Only column A.
Every sheet will be add below the previous group.
I would like to ask for your kindly help in this task.
Step 1:
When select Column A= count 11 or 16 rows, (will never exact count amount to group Column A), and will assign a number in column B, creating a group.
I have to create 8 sheets with different number column A & B, never the same amount of sheets
I am doing manually, I am looking for a VBA code to automate the process.
I found conditional formatting but take time from 1 to 99 colors , every week change the excel files with new data.
The second step2 : All sheet1 until sheet8. Never will be the same sheets. Need to copy in one new sheet. Only column A.
Every sheet will be add below the previous group.