Auto populate tabs from master tab and share across multiple files

[jangell]

In my sample file below I would like to move the details associated with a specific vendor number to a sheet in the same workbook.

In my example file for instance lines 3 and 9 are both for the same vendor. I would like the info from those lines to populate the tab titled Jeff's Drywall and any subsequent entries to populate the same spreadsheet.

Same thing for lines 2 and 7 - I would like the info from those lines to populate the tab labeled DJ's Framing and so on for any vendor number that is recorded on the master sheet - I understand that i will have to add new tabs for each new vendor that I add to the master sheet and paste formulas into that tab to populate the data.

My ultimate goal is to share a separate link to a worksheet with each vendor that will automatically update from information contained in the tab associated with their business.

For example - I would create a new file for Jeff's Drywall and send this file to the vendor - The file would automatically update each time they open the file with any information that is in the Jeff's drywall tab from the example file here. The new file wold connect to this sample file via a shared folder.

Clear? Sort of a poor man's web tool...

SAMPLE FILE
https://www.dropbox.com/s/y53q6n4tuswiols/Sample 1.xlsx?dl=0

 

[jangell]

Is this something that is possible to do?

Would appreciate any assistance that you might be able to lend.

 

[My Aswer Is This]

I never open files.
Please assume we cannot see your file and give specific details knowing all we know is what you tell us.

 

[jangell]

Here is an image of the sample file




hope this is helpful.

 

[My Aswer Is This]

Are you wanting the script to look down column B starting in row 2 and copy that row to the sheet name found in column B?

And continue down to last row in column B of sheet named Master Sheet

And all these sheets have already been created. And the value in Column B is the exact sheet name.

So if David is in Column B this entire row will be copied to a sheet named David.

Is this what you want?

 

[jangell]

Yes, or key off of the number in column A.

I giess that that if I want to do that I have to rename the tab or put a reference to that number in the tab itself?

 

[My Aswer Is This]

Try this:
Run this script from your Master Sheet.
Script starts on row(2) and copies row to sheet name in column B

Sub Copy_Row_ColumnB()
'Modified  9/14/2018  1:31:58 AM  EDT
Application.ScreenUpdating = False
Dim i As Long
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "B").End(xlUp).Row
Dim Lastrowa As Long
    For i = 2 To Lastrow
        Lastrowa = Sheets(Cells(i, "B").Value).Cells(Rows.Count, "B").End(xlUp).Row + 1
        Rows(i).Copy Sheets(Cells(i, "B").Value).Rows(Lastrowa)
    Next
Application.ScreenUpdating = True
End Sub