If cell exists in another tab, how to copy entire row

[nickbsensory]

up vote
0
down vote
favorite
hoping somebody can help as I'm rather stuck!

I have a Master tab which displays all individual products I sell. Each product has a unique Product Code.

Other tabs contain things like bundles, displaying a small select amount of products,all of which can also be found in the Master tab.

I want in place a formula, whereby if I enter a product code in a new tab, it will locate the same product code from the Master tab and copy the entire row to this new tab. Furthermore, if the price in the Master tab changes, I would like it to automatically change the price in the new tab where the same product exists.

On the Master tab, the data ranges from A3:S904 (row 2 has the table headers). The product codes are in Column C; this can be moved if a formula would require so.

Looking forward to suggestion, Thanks

[nickbsensory]

I believe the solution may involve vlookup but I seem to struggle with the part of the formula that involves crossing different tabs

[Kaper]

Sorry to say so, but your descriiption is not clear (at least for me), so please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[nickbsensory]

Apologies that I have been somewhat unclear so far!

I've taken screenshots, hopefully this will help.

excel1.PNG
This is a screenshot of the Master tab with all the products on.

excel2.PNG
This is a screenshot of another tab which will be a bundle of three products.

If one of the products in the bundle were to be Ball Pool Balls, with product code 100163,
I would like to be able to type in "100163" into cell A8 of the tab in the second screenshot,
and all the other values in the entire row would autopopulate.

[nickbsensory]

Hope this is clearer.