I would need some helps to create a VB code that can faciliate the process below.
I have a spreadsheet with two Tabs, Say Tab-A and Tab-B
Tab-A contains data from range A1:A100
Tab-B is just a form.
I would like to create copies of the form (Tab-B), based on number of data on Tab A. Thus, in this example, there will be 100 copied of Tab-B created, the name of each Tab should be the same as the Cell A1, A2... A100. And I also need the value of Cell A1...A100 on Tab-A copied to the Cell A1 of each new tab created.
Thanks all for your helps...
Bookmarks