Good afternoon
I have a sheet that is formatted for the benefit of the planning team where i work, unfortunately the format only is of use to them and does not seem very easy to extract my relevant data.
I believe the best way to do this is to utilse some form of VLookup which will sort the information into another table set out for my requirements, However I am at a loss as to where to start.
Basically I need to extract the information so it shows me the quality code and the total number of times each quality is to be made 1) by day and 2) as a total for the week.
Ultimately I am trying to get 4 lists into 1 requirement list by day and by week
The reason I need this data is so i can then utilise it as a reference list for working out total requirement based on qualities made per day, therefore i would have to set the sorted list in such a way that i can use it alongside 2 other lists.
I really am not explaining this well at all sorry
I have attached 2 spreadsheets the one titled planning is the list that i am requiring help sorting the other one shows all the list I will be trying to use to generate my total requirement needs. Each list will be manually imported into excel each week for now.
In the planning list the info i need is in column C (for sunday) =quality code And Column b equals number of times that quality is to be made, its columns f & e for monday, columns I & H for tuesday etc etc
I just want to be able to download the 3 lists and from that a fourth list is created that tells me how many times each day a certain type of scrap is required.
Anyway 1 step at a time
All help as ever is greatly appreciated however i have a feeeling there will be more questions to be answered before anyone can help me with this.
Thank you in anticipation
2nd spreadsheet to big to upload at the minute sorry
Damion
Bookmarks