Hi all!
I'm making a template that requires variable rows in certain sections. I had initially started with simple inserts based on the row, but didn't think about how the row referenced would change based on inserted rows above it.
I then tried to tailor it based on what I found here: https://www.extendoffice.com/documen...ell-value.html but seem to be missing something. Since the sections where rows would need to be added have headers, I think I can use them as a reference to add rows below it with each button press, but I'm having a hard time figuring out how.
I've attached a copy of the file to make things more clear. I would have to add rows under "LABEL CLAIM," upwards upwards of 50 rows, as well as rows under "ACTIVE INGREDIENTS WITH A CONCENTRATION CLAIM ON LABEL", under "ACTIVE INGREDIENTS THAT DO NOT HAVE A CONCENTRATION CLAIM: PROPRIETARY BLEND" and under "EXCIPIENTS". So I think if I reference the cells that contain that text, I should be able to insert rows beneath them, right?
Thank you for your help!
Bookmarks