Please see attached.
Sheet 3 is a tally sheet. Showing the total for a single customer over a week period. The number needs to be represented by the ship day from June 2016. Daily Entry is just an data entry form but ties to June 2016 by a formula to count as well.
What I am trying to do.
Example: Calply Orange (multiple entries on report "Daily Entry")
1) Entry is made on Daily entry
2) these numbers add together for like customers and transfer to June 2016
3) At this point, I need the data from June 2016 to add up by weeks (m-f, of course) onto my current report at Sheet 3.
4) Giving weekly totals per customers listed on Sheet 3
Can anyone help with this?
Sheet 3 is a tally sheet. Showing the total for a single customer over a week period. The number needs to be represented by the ship day from June 2016. Daily Entry is just an data entry form but ties to June 2016 by a formula to count as well.
What I am trying to do.
Example: Calply Orange (multiple entries on report "Daily Entry")
1) Entry is made on Daily entry
2) these numbers add together for like customers and transfer to June 2016
3) At this point, I need the data from June 2016 to add up by weeks (m-f, of course) onto my current report at Sheet 3.
4) Giving weekly totals per customers listed on Sheet 3
Can anyone help with this?