Good evening. I'm a week and a half into a project for work that I'm hoping will assist in warding off some decisions that would jeopardize the flow of necessary clinical information to front line staff. I am familiar with Excel but as of a week ago I had not tapped into the potential of Excel. Since then I've learned just how little I do know about Excel as well as the AWESOME functionality that the program offers. I am at the infant stage when it comes to coding (VBA) and beg your patience with me as I launch my first couple of questions regarding my current dilemmas with the forms I've created.

My unsolved issues thus far are as follows:

ISSUE

Instead of having the goals and objectives already in the form I would like to have buttons that would allow my clinicians to add as many goals and objectives as they'd like to the attached treatment plan. I'd like them to be able to click a delete button as well when they review the plan and need to delete a goal that's been met. When my team clicks into the second worksheet they would see rows 10-16 (below). They would then type a STG 1 and an Obj A. They then would click the Add Obj button and add as many objectives that they needed. Then when they clicked the add goal button a blank copy of rows 10-16 (including the Add Obj button) would pasted one row down and would update to read STG 2. Neither of these buttons would appear when the document printed.

Here is a screen scrape of what I'd like the attached form to look like before goals and objectives are added.

add goal.jpg

The original form is saved in an .xltm format but I saved it in an .xlsm format so I could upload it here.

HCT ITP (2-25-14) Abbr.xlsm

I found a thread on this forum that came close to answering my question but my attempts to pull out the coding that I needed was unsuccessful. Here's a link to the thread:

http://www.excelforum.com/excel-prog...matting-4.html

Given that this is my first post I thank you for your patience as I figure things out about the forum and how it all works. Thanks.

Matthew