Extracting row(s) of data based on a single column (text field) [SOLVED]

[gregorii77]

Hello! I have a spreadsheet (single tab) with data arrayed as follows:


Project Number Cost Completion Inspector Name

0001234 $78,000 9/9/2013 Tribble

0123344 $90,567 8/1/2014 Simmons

9900445 $43,000 7/23/2014 Simmons

4566723 $56,700 6/4/2013 Tribble

1122995 $96,500 5/3/2013 Steele


I would like to extract rows based on the columnar heading

Inspector Name and place these names in separate tabs.  So,for example, the data above would be contained in a tab called,let's say, [code]Master while the rows associated with Tribble

would be contained in one tab, the rows associated with Simmons[/code]in another, etc. In the end, I would like 4 total tabs (Master, Tribble, Simmons, Steele). Hopefully that makes sense. I appreciate any advice and good day to you!!! Cordially, Greg S.

 

[Hui]

Gregorii77


Firstly, welcome to the Chandoo.org forums


You may want to have a look at:

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


ps: I knew this link would come into use one day:

http://chandoo.org/forums/topic/useful-and-popular-forum-posts

 

[gregorii77]

Thank you for the kind welcome! Ok, I looked at the post, however, I have the following question: if I decided to change the "Employee Code" from, let's say, 1 to 2, how does the sheet "refresh" itself to reflect the change? What about adding rows? I may have missed something, so I apologize in advance. Thanks again Hui!


Greg S.

 

[gregorii77]

Ah, I figured it out!!!! Thank you for your time. I really appreciate it!


Greg