Sorting data into different worksheets-Excel
Closed
Hello,
Here is my issue. I'm using Excel 2003, and I have a worksheet going with a list of names in column A, and their job title in column B. What I'm wanting to do is have it automatically fill the names into Column A on subsequent worksheets, based on their job title. Worksheet 2 is going to be one title, worksheet 3 is going to be another, etc.
I'm wanting to find a code to do this automatically, so when new names and titles are added to Worksheet 1 (Roster), they will automatically be added to the appropriate worksheet for their job title.
If anyone can help me with this, I would very much appreciate it.
Thanks!
Here is my issue. I'm using Excel 2003, and I have a worksheet going with a list of names in column A, and their job title in column B. What I'm wanting to do is have it automatically fill the names into Column A on subsequent worksheets, based on their job title. Worksheet 2 is going to be one title, worksheet 3 is going to be another, etc.
I'm wanting to find a code to do this automatically, so when new names and titles are added to Worksheet 1 (Roster), they will automatically be added to the appropriate worksheet for their job title.
If anyone can help me with this, I would very much appreciate it.
Thanks!
Related:
- Sorting data into different worksheets-Excel
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Insert gif into excel - Guide
- Number to words in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 20, 2010 at 11:54 AM
May 20, 2010 at 11:54 AM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
May 21, 2010 at 09:39 AM
https://authentification.site/files/22551237/SampleBefore.xls
https://authentification.site/files/22551238/SampleAfter.xls
May 21, 2010 at 09:50 AM
May 21, 2010 at 09:56 AM
May 21, 2010 at 10:02 AM
May 21, 2010 at 10:31 AM