Hi All,
I’m looking for some assistance with writing VBA. Please see the attached screenshot of the sample worksheet. The objective is to create a macro that will run through this sheet and create a .PDF saved on the user’s desktop. I believe this may require use of coding that I am conceptually familiar with but not adept at using yet. The need is to fill in the <text> below and have that script saved as a .PDF file.
Script to display on .PDF file
Staff worked with <Name from Column A> <Count of shifts from Column C> times this month.
During that time, the following goals were worked on: <Individually list the goals from Column E and Count of each goal occurrence> (Example: ADL: 5 times, Night Supervision: 9 times, Hygiene: 2 times, etc.)
<Name from Column A> responded positively <Count of “Positive: Loved” and “Positive: Enjoyed” occurrences from Column F> (Example: Loved: 1 time, Enjoyed 5 times) to all activities this month.
I’m looking for some assistance with writing VBA. Please see the attached screenshot of the sample worksheet. The objective is to create a macro that will run through this sheet and create a .PDF saved on the user’s desktop. I believe this may require use of coding that I am conceptually familiar with but not adept at using yet. The need is to fill in the <text> below and have that script saved as a .PDF file.
Script to display on .PDF file
Staff worked with <Name from Column A> <Count of shifts from Column C> times this month.
During that time, the following goals were worked on: <Individually list the goals from Column E and Count of each goal occurrence> (Example: ADL: 5 times, Night Supervision: 9 times, Hygiene: 2 times, etc.)
<Name from Column A> responded positively <Count of “Positive: Loved” and “Positive: Enjoyed” occurrences from Column F> (Example: Loved: 1 time, Enjoyed 5 times) to all activities this month.