In Progress

Private Project for Andrey: Macro Change #4

Andrey:

*** If you can complete this Macro today (October 11th), I am prepared to pay a higher price or a bonus.

This is a new change that I need you to make to your Macro and the old Macro.

1. The first file is named pre-converted-file-macro-change-4-converted.xls. This is data that has been converted by your data. Everything is correct in this.

2. In the “pre-converted” tab/workbook, there is a column named “MTG Retail”. This has a price in it. I need this price and data to show in the converted file and also in the CSV files that are generated by the old Macro.

3. Now look at the file named “[url removed, login to view]”. In the “converted” tab/workbook, you will see a new column named “MTG Retail”. I have copied the pricing from the “pre-converted” tab/workbook column with the same name and copied the data here.

It is not absolutely necessary to create a new column. If it makes your work any easier, you can change the “Cost” column to “MTG Retail”.

4. When you run the old Macro by going to View, Macros, View Macros, and then choosing the Macro named “createfile”, this will generate two CSV files.

5. I have created two files to show you what the CSV files should look like. I have saved these in Excel format to keep the highlighting to show you how the data needs to appear in the CSV files.

6. In the file named “[url removed, login to view]’, there are three lines of data highlighted. In these three highlighted lines, there are two cells in red. The old Macro must create these three lines for every individual SKU. I highlighted the 2 cells in red as this is the important data.

7. In the file named “full.attributes.export..xls”, I have highlighted the lines of data that need to appear.

Please quote me a flat fee to make this change and tell me when you can have this corrected.

Skills: Visual Basic

See more: visual basic cost, format pricing, tab 4, project fee, october 14, macro, macro excel, flat price, flat fee, correct csv, change red, andrey, macros excel basic, excel csv tab, excel macro csv, generate project file macro, xls visual basic, csv column format, change column, workbook csv, project prepared, project macro, project export excel, private show, create workbook

About the Employer:
( 48 reviews ) Staten Island, United States

Project ID: #1243036

Awarded to:

Krusche

Please check PMB for more details.

$60 USD in 2 days
(22 Reviews)
5.5

4 freelancers are bidding on average $170 for this job

junbest1986

Sir, I will provide your needs, please see PM

$200 USD in 1 day
(3 Reviews)
3.4
veera1365

Worked on several challenging tools in VBA.

$170 USD in 2 days
(0 Reviews)
0.0
iosifrn

Hello, I have over 15 years of programming experience in MS Access, VBA, Excel, Web Development, ASP.NET, SQL Server, ORACLE, C#, Visual Basic and others. I worked for companies like SIKORSKY, GE Aircraft Engines, U More

$250 USD in 1 day
(0 Reviews)
0.0