Hi there.
I am needing a macro that takes data inputted from one worksheet (the one with the macro) and creates a new macro template from that data once a button is pushed.
E.g
Inputs - 6 (user inputted value)
Controllers - 3 (user inputted value)
Cameras - 4 (user inputted value)

The macro would then create a new workbook such as below:

Inputs
new row 1
new row 2
new row 3
new row 4
new row 5
new row 6
Controllers
new row 1
new row 2
new row 3
Cameras
new row 1
new row 2
new row 3
new row 4

The macro would also need to have the ability to copy specific text from a cell in a sheet within the workbook to another cell in the new workbook.
I hope this makes sense....


Regards...