• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Req. Daily / Monthly Dealer visit calendar of 10 employees

Nitesh Khot

Nitesh Khot

Member
Hi....,

I want template of Daily / monthly visit of dealer. Where in templete
Sheet1 contains raw data of employee visit details and one drop down menu. If I select any of employee name then sheet2 auto update with visit calender details of that employees whole month.

Kindly help me in this regards, this is an my practical exam question.


I am awaiting for your quick reply appreciate.

Regards,
Nitesh
 
Hi Nitesh,

I would suggest you to upload a sample file with some raw data and output format required. This will relieve the other users of the forum to build a complete one and you will get a quick response.

Regards,
 
Respected Sir,

I Have attached file and made some modification as below.
1) sheet - Raw Data contains date of visit time, Emp name , Dealer name and time of informed to supervisor
2) sheet - Calender - Contains calender ..if visit done the display VISIT else blank.
3) Sheet - Auto Report Update - If i select name from Raw data dropdown list then here auto daily & monthly report will be generate.


Kindly help me in this regards asap.

Regards,
Nitesh Khot
 

Attachments

Dear Sir,

Could you please explain me how this formula works and how you do?

Also if you have any pdf file of excel formula and VBA macros please send me.?

Nitesh
 
You must log in or register to reply here.
Back
Top