Can i create daily dairy on excel or access?

[m.shahbaz]

Actually I am still confused to describe my question lol but let me try, well i want to create a dairy on MS Excel in which i want put my daily working, I am a medical representative and my job is to visit doctors ok now my all doctors are coded by company, if i make a daily dairy on excel then it will be easy for me to check my routine working, is that possible if just enter just code of specific doctor in one cell and other cells complete automatically like name of doctor, specialty, clinic area and visit time.. please help if i can do this with excel formulation.. Thank You

[AliGW]

Welcome to the forum!

Yes, it is all possible. Best thing is to provide a workbook showing the layout you want.

[m.shahbaz]

Thank you so much for your reply here is the example what i want:

Sr # Dr. Code Dr. Name Specialty Clinical Area Visit Time
1 20194 Asif Hayyat General Practitioner Al Faisal Town 9am

if i enter just fill Dr. code and remaining fill automatically..

[m.shahbaz]

Sr #	Dr. Code	Dr. Name	Specialty	Clinic Area	Visit Timing
1	20194	Asif Hayyat	General Practitioner	Al Faisal Town	9am

[avk]

using vlookup you can do.
Suppose your data in sheet2 as per your table shown.

In sheet3 "A2" is Dr.Code
Put formula in "B2"

=VLOOKUP($A2,Sheet2!$B$2:C$7,2,0)

In "C2"

=VLOOKUP($A2,Sheet2!$B$2:D$7,3,0)

In "D2"

=VLOOKUP($A2,Sheet2!$B$2:E$7,4,0)

In "E2"

=VLOOKUP($A2,Sheet2!$B$2:F$7,5,0)

[m.shahbaz]

using vlookup you can do.
Suppose your data in sheet2 as per your table shown.

In sheet3 "A2" is Dr.Code
Put formula in "B2"

=VLOOKUP($A2,Sheet2!$B$2:C$7,2,0)

In "C2"

=VLOOKUP($A2,Sheet2!$B$2:D$7,3,0)

In "D2"

=VLOOKUP($A2,Sheet2!$B$2:E$7,4,0)

In "E2"

=VLOOKUP($A2,Sheet2!$B$2:F$7,5,0)

Thank you so so Much this was the excellent idea and i did exactly what i want to do..because of your help..

[JohnTopley]

See the attached: this is based on a diary/calendar routine from "Pete_UK"


Tab "Doctors" has the details of Doctors .

The "Activity" column concatenates the details from "Doctors" based on "Dr code" plus "Visit Time" .

[m.shahbaz]

See the attached: this is based on a diary/calendar routine from "Pete_UK"


Tab "Doctors" has the details of Doctors .

The "Activity" column concatenates the details from "Doctors" based on "Dr code" plus "Visit Time" .

Thank you so so much to you also your post give me another idea to put all data in calendar as well.. Awesome

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[m.shahbaz]

Hey @JohnTopley

See the attachment i make this sheet, if i want to add calendar in it, like you did then how can i do?? two sheets in it LookUP and Daily Dairy if i want to add third Calendar linked with Daily Dairy..
Thank You

[JohnTopley]

See attached:

[Pete_UK]

I think it would be better to use the Lookup sheet just for the doctors' details, and to enter the Doctor code and time of visit in the Activities sheet, as John originally had it, otherwise you will be entering duplicate doctor details on the Lookup sheet.

Pete

[m.shahbaz]

See attached:

All good john thank you so much, all done with excel now is the any option to create a database app or website like this excel sheet work behind that app i just put the doctor code and submit button and it appears in calendar which you make.. I mean i want to shift this all into app or website presentable results by just putting doctor code and submit..
May be i explain what i want..

[JohnTopley]

Please post a sample file showing how you wish this to work.

[m.shahbaz]

I havn`t sample bro but let me try to explain again,
I need a website or mobile app with two pages calendar and submission

Visit Date	Visit Time	Doctor Code
1st jan, 17	09:33am	20194

This is all on submission page with submit button, I just put data in these text boxes and click on submit then it will redirect me into calendar page.. and at the back end same excel file which you already send me will work.. Actually i want to switch from excel into website or mobile app but working is same which we did in excel..

[m.shahbaz]

I havn`t sample bro but let me try to explain again,
I need a website or mobile app with two pages calendar and submission

Visit Date	Visit Time	Doctor Code
1st jan, 17	09:33am	20194

Submit

This is all on submission page with submit button, I just put data in these text boxes and click on submit then it will redirect me into calendar page.. and at the back end same excel file which you already send me will work.. Actually i want to switch from excel into website or mobile app but working is same which we did in excel..

[JohnTopley]

I don't have any expertise in switching data to a web site or mobile device.

Quick search on the WEb shoes there are applications available to do this.

example

http://www.spreadsheetconverter.com/...FVXnGwodll0Aiw

[m.shahbaz]

See this is what i want https://dailydairy.000webhostapp.com/dailydairy/
I create this but its not working like i told you to put data and submit.. Its just showing excel sheet unable to edit also..

[m.shahbaz]

See this is what i want https://dailydairy.000webhostapp.com/dailydairy/
I create this but its not working like i told you to put data and submit.. Its just showing excel sheet unable to edit also..

[JohnTopley]

"Dangerous website" according to Norton!!!!

[m.shahbaz]

"Dangerous website" according to Norton!!!!

LOL!! But its just a wordpress free script bro with free web hosting well no problem

[JohnTopley]

Message from "Norton"

This is a known dangerous website. It is recommended that you do NOT visit this site.

So I won't!