Create a script based on an excel spreadsheet already created

[VikG]

Hi

 

I want a script that effectively does what my excel spreadsheet is doing which is heavily reliant on Macros.

 

In summary the script needs to:

 

Create a price to sell based on numerous factors and then submit to an external software used which is probably the most complicated part of this.

 

I have the following parts to this:

 

1. Download latest file sheet from external website (login required)

2. Download our database of SKU and Cost prices from an FTP location

3. The file contains a SKU which is used to establish our cost price. However, the SKU is not identical to our database SKU

4. Using a lookup table and some "find and replace" actions match the SKU from section 1 to SKU in section 2. SKUs that cannot be matched in either of these ways then need to be automatically added to the lookup table and manually filled in with SKUs matching part 2 file.

5. Then using a rate card and some rules I need to calculate the selling price. This will then be sent to the external website as in part 1 in a CSV format.

 

Is anyone able to do something along these lines?

 

Thank you in advance.