no it's in an another excel sheet
331688 and 583176 the column of the due dates is in 583176 local column R
yes the file name is XXXXX XXXXX orders list, local worksheet column R ( being the due dates ) and i want the column L once the date is due to flow to the other excel sheet being the projection, sheet 1, and the flowed number to be shower under the same month of the due date
yes it's ok
i mean yes its column T because the worksheet opened from your side is travel & hotels as for the figures yes i want them to be summed
yes it's ok with me i will wait hopefully you will be able to find someone.
Thank you for your patience. We will continue the search for a professional for you.
the content in column L to be copied should go to the month of the same month in the due date
yes i want all the due dates for a specific month to be summed together and shown in the projections sheet as one number ie: from L2 to L8 have due dates on April so in the projections sheet under April i should see the sum of L2 to L8
In order to accomplish this, I need to create a NEW sheet that will perform #2 above. I called the sheet Overdue_Status.
The purpose if this sheet is critical. It will convert the due date into months and it will test the entries if it is Overdue or Not Due. Also, I copied the PO Total values in Column L in this sheet.
Then, in order to push the SUM of all Overdue items, the formula will now test the conditions in the Overdue_Status sheet. The appropriate formula is SUMIFS(). In this case, You sum the PO Total column IF:
In this case, only Overdue entries for the month of April will be totalled under April. The same logic applies in the other months.
Also, I added Projections sheet as a testing before I worked on the separate Projections file.
Here are the download links:
http://wikisend.com/download/752012/Purchase Orders List 2013-4_jess.xlsx
NOTE: Since the Projections file is dependent on the PO List file, the 2 files must be saved in the SAME folder. Also, you can see the Projections sheet the results of the formulas that I made for you.
Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated! If you have any other questions, please ask me or reply to me – I’ll be happy to respond. Thank you!Best regards,Jess