I am trying to make a delivery schedule for my work, my current one looks like this:

Current Layout

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:

New Sheet Creation

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.

  • Do you know how to create an script on Google Sheets? – Rubén Jan 17 '18 at 15:51
  • Yes, I'm not necessarily good at it, but I understand the basics – whowantsmalk Jan 18 '18 at 6:19
  • Good. Have you tried to write the script by yourself? By the way, it looks to me that you are confusing rows with columns (Columns have letters and rows have numbers as headers) – Rubén Jan 19 '18 at 23:41
  • I have tried but with no luck, when I say 'M1' etc... I refer to column B, with 'M2' being column C, so on. 'M1' is just the header of that column. – whowantsmalk Jan 22 '18 at 1:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.