balrajsingh78
New Member
- Joined
- Apr 5, 2021
- Messages
- 4
- Office Version
- 365
- 2019
- Platform
- Windows
- Mobile
I have a worksheet with a long list of customer names and an identifier along with some other information. I can easily sort them alphabetically, however, I need to separate all customer records (rows) for customers with names starting with 'A' in one worksheet, all those starting with 'B' in the second worksheet, and so on. So in brief, starting at row 2, the code needs to:
1) Copy all rows with customer name starting with A to the worksheet named 'A' (copy into rows 2 onwards)
2) repeat the same for every letter of the alphabet, copying the rows into separate sheets.
Please Note: Row 1 will have a header, so it needs to be ignored. Column A has the customer identifier. The column to be filtered is 'B'.
Can anyone please help?
#Others have asked similar questions, but none of them seemed help in with particular issue.
1) Copy all rows with customer name starting with A to the worksheet named 'A' (copy into rows 2 onwards)
2) repeat the same for every letter of the alphabet, copying the rows into separate sheets.
Please Note: Row 1 will have a header, so it needs to be ignored. Column A has the customer identifier. The column to be filtered is 'B'.
Can anyone please help?
#Others have asked similar questions, but none of them seemed help in with particular issue.