Hi, Looking for some guidance. I want to automate a monthly delivery/invoice report.
Various chemicals are delivered to various locations during the month. I need to generate a total invoice for the month for the parent company.
The delivery information is taken from the Master Data (cells highlighted in yellow) and moved to the Invoice Sheet where some calculations are done (hightlighted in blue). The number of deliveries varies from month to month.
Please see attachment.
any guidance would be appreciated.
Bookmarks