1- We use Shipworks app to pull orders from Amazon and other sales channels.

2- One field is the item number. The format for one company, Fotolia, is 'FOT-12345-24'. FOT is the prefix for Fotolia. 12345 represents the item number. 24 represents the size in inches. There are various sizes, all have two digits.

3- We have other vendors, so we will sort all the Fotolia orders first, from all the NEW orders.

4- We need to REMOVE the 'FOT-", and the '-24' that follows the item number, leaving just the item number. This list of items can be put on a notepad or excel spreadsheet maybe.

5- I want to go to [url removed, login to view], and while logged in to my account, have each item number be added to the shopping cart, with the medium size selected.

6- The macro would run down the list until every item was added to the cart.

7- The macro needs to be able to run down the list of item numbers and not continue to keep the first item.

Can someone do this? I'm looking to have this done ASAP. You will need remote access to my computer at the office once you prove you can do it.

9 freelancers are bidding on average $179 for this job

Hello, my name is Cristian, I have a degree in Business and am Financial Advisor. Besides working with excel every day. I have much experience with spreadsheets, complex formulas and macros to process the information.
Mais

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positiveMais

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have beeMais

Hi
I can assure you that i am having the best excel experience and i can do almost everything possible with excel.
Please check my review in [url removed, login to view]
IF you need see some samples of my work, then, pleasMais