I have a worksheet with 12 different columns and an insert row command button where users can add rows as they input data into the rows. I have created a separate spreadsheet. where I would like to have a tabulate command button that the user can press and it would populate the table with all the data from the relevant columns. Some of the columns in this spreadsheet would be reserved for calculations as such these cells would have formulas that would read from the columns that have been auto filled from the command button. Is there a VBA script I can use for this command button?
To further elaborate, I have attached two screenshots. I wish to copy all the inputted data from columns B, D, G, IK, L and M in the capture.png screen grab into the columns in the relevant columns into the 2nd spreadsheet. (Capture 2.png screen grab) It would have to be dynamic as the number of rows depends on how many rows the user inserts in the first worksheet. The table would also have to be formatted with border lines and colour. Columns I to L in the 2nd spreadsheet will have their own formulas so that would have to be copied into the dynamic creation of the table.
To further elaborate, I have attached two screenshots. I wish to copy all the inputted data from columns B, D, G, IK, L and M in the capture.png screen grab into the columns in the relevant columns into the 2nd spreadsheet. (Capture 2.png screen grab) It would have to be dynamic as the number of rows depends on how many rows the user inserts in the first worksheet. The table would also have to be formatted with border lines and colour. Columns I to L in the 2nd spreadsheet will have their own formulas so that would have to be copied into the dynamic creation of the table.
