I'm looking to have a final summary of costs for equipment totaled from a workbook consisting of 10 pages. The equipment is under code 2 and there are many other codes used for labor, subcontractors etc..
I'm thinking using a IF statement to scan through the cells in the previous pages to look for a code 2 the printing the corresponding costs on the total page?
Wondering how i can make a IF statement so that if false the operation is to check the next cell down (check another cell) and If True print a value associated with that cell then check another cell?
I guess I'm looking to create a loop that preforms multiple IF, AND, THEN statements?
Thank you anyone who can help
