I am working in a workbook with numerous worksheets. The first worksheet is a summary of all widths, lengths, and control locations used for a project. I am using it as a key for the individual floors of a project.
Column A is list of alpha characters. Each character represents a specific width, length, and control location. The additional worksheets are floor specific. For instance, Floor 1 is a worksheet, Floor 2 is a worksheet, and so on. These worksheets show the actual measures for each floor. I need to assign the "master" alpha character when all three conditions are met for a specific letter. The purpose is for me to know how many type As, Bs, Cs, etc. that I need to order for each floor, and for the complete project. Please help!
Thanks,
Cliff
Bookmarks