Hey all. First day and hope to advance in Excel VB script writing and macros but I have a delema (spread sheet attached). The spread sheet has 4 tabs. The master tab recieves a large bulk of information and I am hoping to copy the rows relevent to the other three tabs to thier sheet. It would be based on the partial names of the items in cell A1. An example would be copy all cells in A1 that start with the name "MED" and past them into the sheet named MED.
The second issue I have is that column C is cluttered with data and I hope to one day extract the small information from that cell and delete the other clutter. It would be the user names that are in parenthesis that begin after the words "#6#TaskOwnerID IN". Crazy, I know
Eventually I will need to have the two issues come together on their prespective Med, Neuro, and Peds tab. Any help out there would be greatly appreciated. Thank you.
Bookmarks