Excel as a data base using Macros, VBA

Excel as a data base using Macros, VBA
Is there a way for me to turn this information into a (very primitive) database? For example, for row "H" it says "Parts?" I would like to somehow create a drop down menu that says "yes" or "no". If clicked Yes I would like to automatically be able to fill in the next columns. If clicked "No" I would like to skip to column "Q" and resume the data entry.

Also notice on row "T" where it says "service schedule date" I would like to create a macro that automatically pulls the necessary information I need (ie: SO, PO, Location Address) into a google apps calendar, that is linked with Outlook.

I have hundreds of rows of data like this in my real spread sheet as this is what i use to keep track of EVERYTHING since my company does not allow us to use any type of CRM/or work order/scheduling software. I use this to keep track of billing, scheduling, clients, contract expiration dates, payroll, commission percentages, etc.

I have been trying to learn about macros and VBA to help myself in some way but I am not finding anything specific to what I need. Please help! I am desperate. Any direction, advice, or tips would be GREATLY appreciated!

Thanks! [ATTACH]139933

Great! It worked perfectly! THANK YOU so much! Any ideas about the excel to outlook cal macro?

Yes through Google apps.

I did exactly what you said on my "sample database workbook" but when i tried to do it on my real database i isn't working! I can't figure out what i've done wrong