Use a Excel macro to move data to uniquely named tabs

Microsoft Excel 2003 (full product)
October 24, 2012 at 14:06:13
Specs: Windows XP, 3.5
Hi
I have to move a list of people that have a unique number to a new tab. See example:

PQR FullName UsName Description two C hart
P01 Hwbssr, Lautten ZHeeeddg MtH - 3B Yes No Yes
P01 Birssher, Wiiyse ZKiiyydW MhH - 3B Yes No Yes
P01 Metoogan, Ktsren ZMtttEK MkH - 3B Yes No No
P01 GuuttsON DOyrsA ZGbbbRD MwH - 3B No No Yes

I have a list of about 1400 like this with different PQR identifiers. I need create and name a tab then move only the data relevent to each PQR code to its own tab.


See More: Use a Excel macro to move data to uniquely named tabs

Report •


#1
Report •

#2
October 25, 2012 at 08:46:41
PQR_Title FullName   UserName  Description       work    erner     hart        P01	Hueb, Maur         ZHUEBM	M - 3B 	    Yes	No     Yes
P01	Kirc, Wini            ZKIRCW	M - 3B	    Yes	No     Yes
P01	McGe, Kare         ZMCGEK	M - 3B	    Yes	No     No
P01	GARR DONN       ZGARRD	M - 3B	    No	No     Yes
P02	Diod, Donn          ZDIODD	R - RAM	    Yes	No     Yes
P02	Ledd, Cynt          ZLEDDC	LH - Plast      Yes	No     Yes
P02	Myer, Rach         ZMYERR	LH - Plast 	    Yes	No     Yes
P02	Prof, Sand          ZPROFS	LH - Plast	    Yes	No     Yes
P02	Cona, Caro         ZCONCA	LH - Plast	    Yes	No     No
P04	Bene, Caro         ZBENEC	ML - Nem	    Yes	No     Yes
P04	Blak, Donn         ZBLAKD	ML - Nem     Yes	No     Yes
P04	Drag, Keit           ZDRAGK	ML - Nem     Yes	No     Yes
P04	Gill, Donn           ZGILLD	ML - Nem     Yes	No     Yes
P05	Alex, Kris           ZALEKR	H   - BrMa	   Yes	No     Yes
P05	Aren, Janz          ZARENJ	H   - BrMa	   Yes	No     Yes
P05	Arms, Susz        ZARMSS	H   - BrMa	  Yes	No     Yes


Report •

#3
October 25, 2012 at 11:37:17
I'm not sure why you reposted your data without any comments.

Did you read the thread I provided the link to? That thread has code that creates tabs and copies data to those tabs in the manner I believe you are looking for.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question