Workbook contains spreadsheets for product test results. Details of all products to be tested in the stated month are entered on Main Page. There exists spreadsheets for each product. I want to list all instances of each product name and batch number from main page to specific spreadsheet with no gaps in rows. I tried using "INDEX" function but get either blanks or #Value errors. I am trying to use a modification of the following formula:=IF(B12>$G$3,"",INDEX(Sorted!$B$3:$B$50,ROW(Sorted!$B$3:$B$50)-3,ROW(1:1))). This formula was taken from a previous thread with similar properties. Unfortunately I am not that versed to fully understand the syntax in order to effectively edit the formula for this application.
Workbook attached.
Main Page: Data entered in columns C to H; Data in columns C, D, and E are candidates for capture.
Sorted: Picks the product from Main Page
APF Gels: Captures Product Name and Batch Code. After all data are entered on Main Page the document is printed and data are manually recorded on individual spreadsheets, then transferred back to workbook for the final calculations.
Bookmarks