49

Excel formatting using macros and script.

UpworkSGNot specifiedintermediate
Data ExtractionPower QueryExpertVisual Basic for ApplicationsExcel MacrosPDF ConversionMySQLAnalytical PresentationMicrosoft ExcelAutomationData AnalyticsGoogle SheetsAutodesk AutoCADData Mining
1. First, Excel contains all the data based on the date range, including fulfilled and unfulfilled orders, along with tracking data (for fulfilled orders) 2. The second Excel contains unfulfilled orders downloaded from Shopify. 3. I need to update the tracking data for unfulfilled orders and delete the orders where tracking data is not available. 4. After updating the tracking data, tracking number, and tracking URL, I need to format the tracking URL using the standard URLs of shipping companies. (Standard URL is based on shipping country and is fixed for each country) 5. Once the unfulfilled orders tracking sheet is ready, I need to format or upload it in Matrixify Excel format so I can upload it in Shopify to fulfil the orders. 6. I need to show you the steps on a video call to understand the process.
View Original Listing
Unlock AI intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/mo

Client

Spent: $50.87Rating: 5.0Verified