I need to create a weekly business review that populates data based on days/weeks. I cannot use a Pivot (sigh)... The attached shows the data (A3-H3). I would like some sort of formula that can then populate the data based on Shift, and the other variables such as Delivery, Pick-Up, Cancel, and Change BUT based on specific date.
it maybe possible to layout the data slightly differently to use the titles
Anyway
You have 2 swing shifts - should one be Night?
see attached - uses SUMIFS()
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you could use names-range
please see attachment
Cheers
Erwin
I started learning VBA because I was lazy...
Still developing.... being more lazy...
Thank you Wayne your answer was very helpful!
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks