In my attached workbook, I'm looking to pull data from one sheet to another as well as the criteria on the second sheet factoring in.
For example, in my workbook I have two sheets, In Sheet 2, I want cells H3:H6 to formulate based on the info in Cells C2:C4 of Sheet 1 (which will always be changing based on number entered) and the results of cells C3:G6 of Sheet 2.
On Sheet 1, Hitting consists of cells C3:E6 on Sheet 2, Starting Pitching cells F3:F6 on Sheet 2 and Relief Pitching cells G3:G6 Sheet 2. I want cells H3:H6 to be listed in order of cells C2:G2 and listed in a drop down menu as well.
What the worksheet should look like when finished is in Sheet 3.
Thanks and please let me know if there are any questions!
Bookmarks