Käynnissä

Private VB Script Project for Krusche-06112012

This project requires that two previous written VB Macros be edited according to our instructions. We are providing step by step instructions as well as files that include the previous VB Macros.

1. I have provided 2 files for you. One is called “Macro Template for Engagement Rings for [url removed, login to view]” and the other is called “[url removed, login to view]”.

2. The file named “[url removed, login to view]” has a column named “Sale Price”. This is column that does not appear in “Macro Template for Engagement Rings for [url removed, login to view]”. It is a formula. The column and data from this column needs to appear in “Macro Template for Engagement Rings for [url removed, login to view]”. It should appear to the right of the “S” column (Total Price).

3. When the data from “[url removed, login to view]” is copied to “Macro Template for Engagement Rings for [url removed, login to view]”, the “Sale Price” column and data needs to appear AFTER the first Macro is run. Here are the steps you created for me. Press ‘Ctrl+Shift+C’ and this will run the first Macro. This will generate data that you can view in the ‘converted’ tab/workbook. The first step involves making the data from the “Pre Converted” column appear in a column in the ‘Converted’ tab/workbook.

4. The “Sale Price” column and data should appear in the “N” (Sale Price) column.

5. Now, this is the next issue. After you have rung the first Macro, you will run the second Macro.

6. On the “Converted” tab, go to Macros, View Macros, and then choosing the Macro named “createfile”, this will generate two CSV files.

7. I have created two files to show you what the CSV files look like. One is named “[url removed, login to view]” and the other is named “[url removed, login to view]”.

8. I need you to make the following adjustments to the data that appears in these files.

9. In “[url removed, login to view]”, please see column “A” (sku). I need you to make the data appear “shorter”. The way to do this is stop the following text from appearing in these cells (-G-SI1orH-VS2-EGL-mm).

10. We have the same issue in the other file. In “[url removed, login to view]”, in columns “B” and “C”, once again, shorten the URLs by stopping this text from appearing (-G-SI1orH-VS2-EGL-mm).

11. I have saved these corrected file as “[url removed, login to view]” and “[url removed, login to view]”.

12. There will be additional changes we want made, but these are the top priorities.

Taidot: Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: what is second shift, vb in excel, text macros, vb excel, pre-press, egl, correct csv, cooper, andrey, macro script file, macros excel basic, excel csv tab, excel macro csv, generate project file macro, stop visual basic macro, workbook csv, 504, excel export template, project macro, csv excel text, macro formula, step project, project export excel, private show, export excel data excel workbook

Tietoa työnantajasta:
( 48 arvostelua ) Staten Island, United States

Projektin tunnus: #1689352

Myönnetty käyttäjälle:

Krusche

We will have to revise the rather complex algorithms created so far. The expected delivery time is 48 hours.

150 $ USD 5 päivässä
(29 arvostelua)
5.6

2 freelanceria on tarjonnut keskimäärin 125 $ tähän työhön

ShiaFirst

I can do these changes. Award the project and let's begin...

100 $ USD 1 päivässä
(23 arvostelua)
6.1