Hi, i am currently doing an appointment worksheets for my dental clinic. im using numbering system (worksheet name) of '01' for January, '02' for February and so on for the month.
google drive link = https://drive.google.com/open?id=1yiM-l4zTW7RvC17iaDJhL-OYymCGGiQZ
inside each month, there are 'list', 'overview' and each date in that month tabs.
tabs:
1. list = where i store all the lists required for data validation
2. overview = calendar-like view for summary of appointments of each day. and notification based system for my assistant to find or update patients report card.
3. dates tab = i named them in 'dd' numbering system. basically its the primary data location. and each tab is for 1 date.
So this is where im stuck
1. i was planning to do is whenever someone pick 'change date' (in attendance column) AND they put a valid date (with dd/mm/yy style) in 2018 in 'new appt date' column, the sheet will automatically do 2 things.
a) create a new row underneath with all the default properties (so we can enter a new appointment for another patient)
b) copy all the patient data to the new date and the font must be in red color (new one). i dont know if this is possible, but if i can also pick the date to paste it into, it would be cherry on top
.
i figure that this need to be done in VBA, and that is where im not custom to yet. if someone could help me, i will be very grateful. Thank you.
google drive link = https://drive.google.com/open?id=1yiM-l4zTW7RvC17iaDJhL-OYymCGGiQZ
inside each month, there are 'list', 'overview' and each date in that month tabs.
tabs:
1. list = where i store all the lists required for data validation
2. overview = calendar-like view for summary of appointments of each day. and notification based system for my assistant to find or update patients report card.
3. dates tab = i named them in 'dd' numbering system. basically its the primary data location. and each tab is for 1 date.
So this is where im stuck
1. i was planning to do is whenever someone pick 'change date' (in attendance column) AND they put a valid date (with dd/mm/yy style) in 2018 in 'new appt date' column, the sheet will automatically do 2 things.
a) create a new row underneath with all the default properties (so we can enter a new appointment for another patient)
b) copy all the patient data to the new date and the font must be in red color (new one). i dont know if this is possible, but if i can also pick the date to paste it into, it would be cherry on top
. i figure that this need to be done in VBA, and that is where im not custom to yet. if someone could help me, i will be very grateful. Thank you.
