After recording what I would like to be done I realized it will only work on a loop and I am horrible with writing loops. I would like to populate columns B and C on the Parts Request tab when on Sheet 1 Column S has yes. If you look at the attachment on Sheet1 S6 is yes no I would like to see B6 the Item # populated to B15 on the Parts Request tab and then A11 (Sheet1) would be populated to C15 on the Parts Request.
Is it also possible to have this automatically populate on the Parts Request tab once "Yes" is selected (from Column s). The example has 37 items populated but the items that may require action can be less or greater.