Good afternoon,
I am having trouble with what seems to be a relatively easy task. My goal is to create a production report summary that takes data from multiple non-adjacent cells and returns them in a summary page. I would like to use a drop down list for days of the week to "autopopulate" the summary area. I realize that I can do this with multiple nested IF statements but was looking for something a little less cumbersome. I have some familiarity with VBA but haven't used it in about a year...
In the attached workbook, the summary sheet takes data from 'PASTE Day' and 'PASTE Night'. It focuses on the Line/Actual value (I.E. cell G6 on sheet Tri-fold relates to cell E5 on sheet PASTE Day). I would like all of the information in column G, H, and I on Tri-fold to update based upon the list in I2.
Thanks in advance for any help!
Bookmarks