Forum Discussion
Connecting Tracking Sheet with Case Questionnaire
Would you be able to share a video or lesson on how to create the VBA code I need? I understand your recommendation, but the concern over the unwieldy number of tabs is not an issue. I will only have at most 15 cases active.
Thank you for your time on this matter.
alandry1330 unfortunately I don't have a good reference for learning VBA/macros. I'm sure there are many good videos online.
I imagine you would add a button to the template that when clicked would:
1. copy the template to a new sheet
2. name that new sheet
3. remove button from new sheet
4. clear template data
5. call routine to add line to tracking sheet (pass the new sheet)
the add line routine would:
1. find next open line
2. copy corresponding cells
as for deleting sheets is that going to be a manual operation?
while you're at it you could also add hyperlink to the tracking so you can click on an item there to take you to that item's sheet.
You can also add a hyperlink on the template (and hence all copies of it) back to the Tracking sheet
but then deleting sheets would cause problems with those links
sorry I don't have time to do this right now