I am trying to make a delivery schedule for my work, my current one looks like this:
I would like to create a script so that when I click a button, a new column is created next to the column furthest to the right that has a header 'M4' and the rest of the column is empty but with the same format as the one to its left. This would repeat everytime you click the button so that it would go 'M5', then 'M6', so on.
From there I would enter data into the column that denotes how many of each item has been sent. After all data has been entered I would like to be able to click a second button which pulls the data from the columns and puts it into new corresponding sheets.
For example, if no new sheets have been created, it would make 3 sheets called 'M1', 'M2', and 'M3'and in that sheet it would look like this:
In this way it only takes the cells from the 'Item' column that has corresponding values in the 'M1' column.
This process would also be repeated for 'M2','M3' and any other columns that have been created.
After the new sheets have been made and I decide to change data any of the 'M' columns and press the button again, it will refresh the sheets to reflect this change.