kidneythief
New Member
- Joined
- Mar 17, 2021
- Messages
- 35
- Office Version
- 365
- Platform
- 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!
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!