Can anyone help??? I have been tasked to write a macro that will take one
worksheet and split it up into multiple sheets. I have found wonderful
information if the cells split information was in the came column but my
issue comes in when I have multiple rows€¦ i.e this is how I need it split by
what is xed) I need all the worksheet to have row A1 (headers), first
worksheet (CD) should have all the information for B2 and B3 worksheet two
(FA) should have B2 and B4 etc€¦.
A B C D
1 Name CD FA RA
2 Fun x x
3 Joy x x
4 Happy x x

Please help€¦. Thank you in advance.