Hi guys,
I do not have anywhere near the technical understanding of excel programming
to achieve what I am trying to with a file we use heavily in a particular company sector I work in.
This is a great place to learn but I am in a position now where my workload hasn't allowed me
opportunity to take the time to research and learn myself like I would prefer.
So.... here is what I am trying to achieve and hopefully one of you
can assist me:
Looking at the attached example, you will see three sheets for each day of productivity
and one summary sheet at the end. They show a list of products in the rows
and the columns denote each customer.
The idea is to gather all figures for the days and display lastly in the summary so we can assess P & L
and that sort of thing for the week.
The issue is that with each product from row 20 to 33 the packaging can be either regular,
or a different kind we call 'Y' packaging
It important that we have a separate count in the summary for the different types of packaging on
these particular items and given the way we utilise this sheet we CANNOT accommodate
enough rows to have each listing as a separate item.
SO, to denote whether the item uses 'Y' packaging or not, we put
a 'Y' in the adjacent column (top half of the cell since its a split).
The problem now becomes obvious that in the summary sheet we need
the column "Y Packaging" to collect data only from the item that is input with a
'Y' next to the count.
The summary sheet is currently designed to pull the figures from the very end of
each daily production sheet (col CO) and add them together.
I did not design this system but I was told that I cannot change it without
considerable backlash from the guys who have been using it for years.
I have experimented with for loops and if statements but have achieved
absolutely nothing useful yet.
I have placed some example data for 1 item (highlighted) in the accompanying
excel sheet to assist any person who might be game enough
to tackle this one.
Appreciate any help that can be given
and will check back regularly to
provide any key information missed.
John
DailyEx.xlsx
Bookmarks