Previous Topic Next Topic

Sorting data into different worksheets-Excel

Closed
Yargsz - May 20, 2010 at 11:15 AM
 Yargsz - May 21, 2010 at 10:31 AM
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!
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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.
0
Yargsz
May 21, 2010 at 09:39 AM
Ok, here's a before and after.... I've done a lot of searching, and I think I want some sort of 3D reference, but I don't know if it works with alpha-numeric values... thanks again for any help!

https://authentification.site/files/22551237/SampleBefore.xls

https://authentification.site/files/22551238/SampleAfter.xls
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 21, 2010 at 09:50 AM
What if you decide to change J. Doe from current OP4 to OL1 on your Roster sheet ? Or any other change ? would it not better to discard old sheets and re create all sheet s ?
0
Yargsz
May 21, 2010 at 09:56 AM
I assumed that it would automatically change, but come to think of it I'm not sure that would be so. But yea, that would be helpful to have it automatically change over. Thanks for mentioning that.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 21, 2010 at 10:02 AM
See above message. I modified after posting it? Bascially asking would it work new sheets are created off Roster sheet
0
Yargsz
May 21, 2010 at 10:31 AM
Are you asking, like, have it recreate those two sheets every time I open the file? That part I'd like to avoid if I could. I'm going to have some more information on the latter two pages to go along with the names.
0

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
AMD data change update new data to DMI
Luis -
dwebb -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses