Periodic Report

[fady77]

Dear users, Thank you in advance for any help you provide me with my post
I was requested from my manager to create a periodic report according to data entry sheet the report is not specified as daily or monthly, i will try to provide you as much information as i can so you can be able to help hopefully
you are free to review the attached file
they are requested to generate a report based on dates selection (From : To)
by entering the dates in the cells (!SheetReport:C5,C6) they want the report to extract the data from DATA ENTRY SHEET regarding each salesman and according to the selected dates
the total offers send for each salseman
the total pending offers for each salseman
the total accepted offer or each salseman
total amount of only accepted offers for each salseman

I tried to search for VBA formulas without any suceed

Thank you in advance for your help

Regards

[ORoos]

Hi there,

I think this can be done with the COUNTIFS and SUMIFS formulas. No need for VBA.
Please refer to the attached file.

[fady77]

Thank ORoos for your help and reply i really appreciated God Bless

[ORoos]

You are welcome fady.

If this answered your question, please make it as SOLVED (under Thread Tools at the top yellow bar).

[fady77]

Done Thank you again

[josephteh]

I believe your "Accepted Offers" and "Total Amount of Accepted Offers" should refer to column M for the dates, not column G. However, there is a problem with how you entered the dates in column M - they are not really dates.

[fady77]

Dear Josephteh thank you for your reply the "Accepted Offers" are refer to the selected dates mentioned in C5 & C6 in the REPORT sheet and the "Total Amount of Accepted Offers" are also refer to the seected dates the ate in the column M are the dates of contract signing which this date can be done maybe after 1 year of the PO Date (column G)
Thank you again for sharing us your opinion