Prize amount increased: Easy Changes to an Excel Template
$10-15 USD
Paguhet në dorëzim
I need a few changes in this excel template.
_Change #1:_
As of today the dispatch number increases by one in the registry when the file opens. I want this number to be increased when they press the print button at the bottom. And I want for it to only increase once per started template instance.
_Change #2:_
When I press the print button I want the values in some cells to be added to a CSV file.
We want to have a CSV file for each month, containing all the deliveries for that month.
So if it is the first delivery of the month, create a new csv file called "Deliveries for [url removed, login to view]" and export some of the cells.
If the file already exists I want it to exports cells from the sheets, by adding lines to the CSV without deleting previous content in the CSV-file.
The format does not have to be CSV, but preferably an open format which is easy to copy/paste into excel.
If there is a item number in column B, we want B, C, D, E and F from the same column exported.
_Change #3:_
When pressing the print button, show a yes/no dialog with the text: "Is the form completely and correct filled out."
ID Projekti: #2787172