Transfer data to another sheet

[srgtennis]

I need to pull the part name from column B and amount of Resprays from the master sheet over to Respray sheet.

If the respray count is above zero then I need it to transfer to this sheet. When it transfers the data I need date column to put it yesterdays date and the used by data will
be 3 days after that.

ThanksBook1.xlsx

[srgtennis]

I want to just have a list of part that have respray quantity. So anything that says we have some respray parts I want it to get pulled from the master.

[AZ-XL]

Master Inventory is protected. Can you unprotect it and the send or tell us the password

[AZ-XL]

Where I can find these column information. In master sheet I cannot see those criterias.
Part, Amount, Racks, Scrap, Date

[srgtennis]

I don't have the password to unprotect. I need column B and D from the master inventory to transfer to the part and amount on Respray tab (column C and D)

[srgtennis]

I could probably make a new inventory sheet that is unprotected if you can't work with it protected?

[AZ-XL]

c3 cell
=IFERROR(INDEX('Master Inventory'!$B$4:$B$161,SMALL(IF(ISNUMBER('Master Inventory'!$D$4:$D$161)*('Master Inventory'!$D$4:$D$161>0),ROW('Master Inventory'!$D$4:$D$161)-3,""),ROW()-2)),"")

d3 cell
=IFERROR(INDEX('Master Inventory'!$D$4:$D$161,SMALL(IF(ISNUMBER('Master Inventory'!$D$4:$D$161)*('Master Inventory'!$D$4:$D$161>0),ROW('Master Inventory'!$D$4:$D$161)-3,""),ROW()-2)),"")

[srgtennis]

Sweet thanks, that works

I would like it to sort by date. Once it moves a item over to the respray sheet. Can I have it add yesterdays date in column A on respray sheet. so then the next day if those aren't used then anything new will be the next days date and will be underneath it.

[srgtennis]

The used by date(column B) on the respray sheet needs to be 3 days after the date in Column A on the respray sheet.

[AZ-XL]

Are there dates mentioned in Master sheet?

[srgtennis]

Not on the master. on another tab there is. The tab "Daily Shipments" cell D1 has the date updated every day. If you could use that. It is not on that book1 that I posted.

[AZ-XL]

Can you post worksheet with additional sheet. Also desired result if possible

[srgtennis]

Here is a new book. I just added the date on the respray tab so you can just use that.

[srgtennis]

Can anyone help with a way to put the date in every time it fills a line on the respray sheet