NoSparks, I understand formulas far more thoroughly than macros, but I'll go whichever way is more straight forward. I'm including an example sheet where I've got a drop down for the pipe size (NPS) and showing the column for the choice of schedule, which is dependent upon the pipe size chosen. The lower table shows the pipe sizes and the available schedules for each.
|