Building End of shift report an Trackers formatting issue

 

I’m trying to auto fill out cells  with values E6-E14 based on cell F1 which is a drop down list with 2 options Days or Afternoons.

 

I want the data from another sheet which is numbers the day and afternoons data is on the same sheet.  Cells H11-19 have the Days data and M11-M19 has the afternoons data .. can anyone help me thanks

By: Jon

Leave a Reply

Your email address will not be published. Required fields are marked *