The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
We are receiving two reports emailed to us from Salesforce in CSV format.
One report has order details on each line, eg OrderId, FirstName, LastName, CardType, TotalAmount, ShippingAmount, TransactionRef1.
The other report has order line items, for the same orders. So for example the fields will include but not be limited to: OrderId, ProductType, SKU, Quantity, ProductCost, Tax.
Both reports have a header row at the top. We want to open these two reports in Excel and then run a macro which will then combine the data into a newly created third worksheet. The data will be displayed as a list of order line items which has some order data combined with it, and with some order data at the bottom of each set of line items and some adjustments to the data.
We will be able to provide sample worksheets and a sample output worksheet. It is essentially just a situation of moving data around so it fits the format that we need for the third worksheet, since this file is being imported int...
Sign in or Register to see more