Populating entire rows in worksheet B from text strings in worksheet A

[dfriedman]

Hi all,


I'm trying to track the activity of several teams, and setting up an excel spreadsheet to help me do that. I have a summary page which has all projects listed together. In one column, I have which teams are responsible for each project. Sometimes, multiple teams work together, so it might say Team A, or it might be Team A, B, and C.


I'd like to create individual spreadsheets that only include the projects for each team (8 teams in all). I don't know how to set it up so that if a cell contains a particular string of text, it will copy the entire row to another spreadsheet. Do I need to use a macro for this? I have limited working knowledge of excel but am learning. Thanks for all your support!

 

[Faseeh]

Hi dfriedman,


Welcome to the forums, please upload some sample data and the existing reports, and rough lay out of what you want to achieve. It is easier to visualize from layouts rather then from wordings...


Regards,

 

[dfriedman]

Unfortunately can't upload the existing reports -- sensitive information. But I think I can use this instead:


http://www.fileconvoy.com/dfl.php?id=g6c4625c1c91da9a19993127313e6aeb27cd457c9b


I've created a very, very simple version of the full summary page. I'd like to have worksheets displaying project data for each individual team, so one sheet that contains all the projects associated with Team A. Another sheet that contains all the projects associated with Team B. Etc. There are 8 teams total, so 8 separate sheets. This way I can give reports to each team without all the other team's projects listed.


I want the new team-specific sheets to copy the entire row from the full summary page whenever a string of text, say, "Team A" appears in a certain column (labeled "Team(s)" in sample). If there are multiple teams listed in the same cell, say Team A and Team C, I want excel to put those projects on both Team A's sheet and Team C's sheet.


Thanks for your help!

 

[SirJB7]

Hi, dfriedman!


This is a commonly asked question and I think there are many solutions posted in this forums.


If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.

http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/


Regards!