Create an excel macro that will create ebay file exchange .csv files

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

I need a macro to run in Microsoft Excel that will use replace a variable in an existing template to create .csv files I can upload to ebay file exchange.

1: Copy all content from sheet 4 to sheet 1.

2: Copy all content from sheet 3 and paste it to the first available line in sheet 1.

3: Replace all instances of ___$$$VAR1$$$___ with the next word in the list from sheet 2.

4: Repeat steps 2 and 3 for the next 199 words in the list from sheet 2, column A

5: If column D in sheet one contains any rows with more than 80 characters, delete all characters over 80

6: Save as [url removed, login to view]

7: Delete all content in sheet 1

8: Repeat steps 1-6 until the word list in column 2 is finished, saving as [url removed, login to view], [url removed, login to view], and so-on, until the list sheet 2, column A, is completed.

Excel Programming

Project ID: #11262302

About the project

16 proposals Remote project Active 7 years ago

Awarded to:

MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can automate this process for you. I've done hundreds of excel projects (both with formulas and macros) and i've never had a single problem. If you a More

$40 USD in 1 day
(136 Reviews)
5.5

16 freelancers are bidding on average $131 for this job

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among More

$150 USD in 1 day
(318 Reviews)
7.4
someka

I can prepare the macro you need with manipulating and using some text functions. Regards..............

$210 USD in 3 days
(96 Reviews)
6.5
abdolah2014

HI I am an excel vba Expert and I can finish your project in less than 5 hours I am ready to start now pm me ......................................................................................................... More

$83 USD in 3 days
(26 Reviews)
5.0
vlayausa

Hello, I am proficient with Excel and VBA and I love this kind of projects. Please contact me for more information, I would love to help you finish this work.

$108 USD in 3 days
(58 Reviews)
4.9
schoudhary1553

Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. More

$66 USD in 2 days
(25 Reviews)
4.1
carlosperezit

Hi Im an expert in .Net technologies. I have been working in banking sw development for the last 20 years Regards Carlos

$66 USD in 1 day
(15 Reviews)
4.1
ENRICOJ

HI. I AM INTERESTED IN ASSISTING YOU. I HAVE EXTENSIVE EXPERIENCE IN MS EXCEL,MS ACCESS AND VBA. IT WOULD BE A PLEASURE ASSISTING YOU ON THIS PROJECT. LOOK FORWARD HEARING FROM YOU. KIND REGARDS, ENRICO

$35 USD in 3 days
(2 Reviews)
1.2
kstudio1

Wonderful project! We are pro in Excel and Data processing. As we are masters of mathematics and control engineering, we will give you a successful result in time. Keep in touch with us,please... Thanks a lot!

$50 USD in 0 days
(1 Review)
0.4
denissboltunove

have a wide experience in macro creation, as a data analyst got similar assignments, hence your request could be resolved very shortly

$155 USD in 1 day
(0 Reviews)
0.0
shemer

Been a while since I've used VBA but this definitely seems doable. My only concern is how soon do you need it?

$555 USD in 3 days
(0 Reviews)
0.0
arjuna425

The project is clear and can be made in one day. I have worked on automating the reports using excel and connecting them to databases. For further details you can get back to me and we can discuss on this. As i said th More

$83 USD in 1 day
(0 Reviews)
0.0
poduzov

Hi I'm an Excel expert with 7+ years of experience and can do this job in 24 hours. Best regards, Denis Poduzov

$42 USD in 1 day
(0 Reviews)
0.0