Macro to create list from master sheet
Closed
needshelp
Posts
1
Registration date
Wednesday November 11, 2015
Status
Member
Last seen
November 11, 2015
-
Nov 11, 2015 at 07:58 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 12, 2015 at 11:04 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 12, 2015 at 11:04 AM
Hi!
I need to create a macro that will generate individual lists for employees based off a master sheet. on my master sheet (that is what the sheet is named within the workbook) I have a huge list of stores in column A that I am constantly adding to, with the number of times each store needs to be visited listed in column B, and the employee that each store is allocated to in column C. There are only about 6 employees, so I need the macro to create 6 lists (one for each employee) when run each week that just show who they need to visit and how often. This list is updated weekly. Can someone please help??
I need to create a macro that will generate individual lists for employees based off a master sheet. on my master sheet (that is what the sheet is named within the workbook) I have a huge list of stores in column A that I am constantly adding to, with the number of times each store needs to be visited listed in column B, and the employee that each store is allocated to in column C. There are only about 6 employees, so I need the macro to create 6 lists (one for each employee) when run each week that just show who they need to visit and how often. This list is updated weekly. Can someone please help??
Related:
- Macro to create list from master sheet
- Master royale - Download - Strategy
- Yu-gi-oh master duel download pc without steam - Download - Strategy
- Google sheet right to left - Guide
- Typing master 11 mod apk - Download - Education
- Create skype account with gmail - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 12, 2015 at 11:04 AM
Nov 12, 2015 at 11:04 AM
Hi Needshelp,
What about using a Filter (found under the Data tab)? After applying just select one of the 6 employees and they will be grouped together.
Best regards,
Trowa
What about using a Filter (found under the Data tab)? After applying just select one of the 6 employees and they will be grouped together.
Best regards,
Trowa