I need specific information from Multiple Fulfillment Files in a folder combined into 1 Master Invoice Template Spreadsheet.
Basically Any Spreadsheet that is dropped into a folder should be formatted into the Master Invoice Template Automatically.
Mapping Information Needed In Invoice Template from Fulfillment Files:
Quantity- Column B in Invoice Template from Column T in Fulfillment File Adding all Quantities under column T in the fullfillment file.
Description- Column C in Invoice Template from the Title of the Fulfillment File
Amount- Column I in Invoice Template coming from Column W- Multiplying Column W to Column T for the result to transfer to Invoice Template
I have attached the Invoice Template as well as a Fullfillment File which will be in a Specified folder so we can have the automation done.
Thanks for the help!
Bookmarks