I currently have a single worksheet based entry form that uses named cell ranges in vba scripts that outputs the structured form data into another workbook where all data for a single form is on a single row.
I want to be able to have multiple worsheets of the same form. So idea is to ask user how many Forms they want, then create that number of the forms (all identicle) for completion.... and then run a script that outputs each form to a separate row in the other workbook
But how do you do that if every Form has the same named cell ranges? Is there a way reference unique sheet# & range?
Hope someone understands what trying to achieve.
Thanks,
Mark
Bookmarks