Hi,
So I have this problem. I would like to create multiple forms from a master worksheet which will basically do the following:
1. Select a range of names manually to be used later as new worksheet names (Selection)
2. Go to the master worksheet "MasterForm" which contains two excel tables (forms)
3. Change the cell A1=A1+1 that is if A1 was 1 now it should be 1+1=2 (This will change the auto-populate fields in the forms
4. Create a copy of the MasterForm rename with the next name in the Selection (step 1)
5. Break the links in the auto-populated fields in the form by copy+paste values
6. Repeat 2-5 until end of the Selection (step 1)
Below is the terrible code I wrote, a frankenstein made of two other codes. The caveat of doing so manually is that because the worksheets contain excel tables you cannot do batch edits across
the tables and only one-by-one.
HTML Code:
Bookmarks