Google Sheets script to copy and sort column contents into other sheets based on matching cells on submit

kidneythief

New Member
Joined
Mar 17, 2021
Messages
35
Office Version
  1. 365
Platform
  1. Windows
Really not sure how to go about doing this so I hope I can get some help here. Here is a sample workbook as reference:
https://docs.google.com/spreadsheets/d/1l6v3j7Ro8aeT2N_s0NDP_0_LKrAWn2v2yv_xeU47chs/edit?usp=sharing

The first sheet is the OUTPUT sheet which will be updated daily by copy-pasting from a separate order collation sheet.
I need a script that will run upon clicking a submit button, to transfer the contents of the QUANTITY columns and sort them into their respective customer sheets by matching it to the ITEM column and the CUSTOMER NAME (either the sheet name or in B2 of those sheets) and matching the DATE column to the date (1-7) in the customer sheet. My actual sheet right now uses "=EOMONTH(TODAY(), -1) + 1", +2, +3, etc. to auto-populate the dates every time the month changes.
So in the sample sheet, I've filled out the customer sheets with how I'm hoping the contents of OUTPUT will be transferred. There will be up to 50 customer sheets per workbook.
Is this doable? I really don't know where to start with this so any help in the right direction would be much appreciated!
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top