Macros needed to process csv files

Closed

Description

I need macro that would do the following:

1. Let me navigate to folder with data to import

2. Select files to import

* Files can be either *.csv or *.txt

* Files are either coma, space or tab delimited

3. Import selected files to one worksheet (either the one which is opened or a new one, doesn't matter). Import each file the following way:

* delimited data imported to two adjacent columns

* if original data is in unicode format, it should be imported as ASCII to avoid problems with Excel importing special characters and recognizing data as text instead of numbers

* add one row on the top of both columns

* put letter "Y" in the cell over the first column

* in the cell over the second column, of given imported file, put the name of the imported file (but without extension)

4. Generate automatically a combined graph for imported data in form of scatter plots with straight lines and without markers, where each "first" column is Y and corresponding second column is X

Some examples of csv files are attached.

Please let me know how fast you can do this job and what will it cost.

Skills: Data Processing, Excel, Visual Basic

See more: top graph, process x, how to graph data, how do you graph data, graph top, graph to data, graph how to, graph data examples, data to graph, text macros, ascii graph, excel macro add, macros excel basic, excel macro txt, add macros, excel csv tab, excel add csv import, please worksheet attached, excel macro row, excel macro csv, tab delimited format, import data macro excel, csv column format, 2013 excel visual basic, txt file import excel

Project ID: #4667553

Awarded to:

domenicoF79

Please, see my PM

$30 USD in 1 day
(1 Review)
0.0

12 freelancers are bidding on average $131 for this job

svet63

Excel/VBA developer since 1997. Can help. Regards, Svet.

$150 USD in 3 days
(77 Reviews)
6.6
mrbrave

A quick job for a VBA expert......Lets start and get it done in few hours.

$74 USD in 1 day
(88 Reviews)
5.5
deepbluetech

Hi, I am an Excel macro expert and can take on the job. Shall complete the job within two days.

$125 USD in 2 days
(88 Reviews)
5.3
kovmisa

i can provide free demo.

$55 USD in 3 days
(13 Reviews)
4.8
DenisSmolentsev

Hello! I have an experience of such macro developement. I was doing it for 10 years. Let me propose you all the best of my experience. Thank you!

$155 USD in 7 days
(34 Reviews)
4.6
jaylancer43

Excel VBA Expert. Please check PM for details. Thanks.

$72 USD in 3 days
(17 Reviews)
3.8
manishadk

Very easy job for me. Please Check PM for details.

$155 USD in 3 days
(12 Reviews)
3.8
vinaygarg1

Ready to start I can do that in 5-6 hours. I am ready to discuss

$210 USD in 7 days
(1 Review)
0.0
zkutch

Hello. More 20 years programming experience. See pmb, please.

$222 USD in 5 days
(0 Reviews)
0.0
brymcgowan

I can turn this around for you in a few hours. Thanks for your consideration.

$100 USD in 3 days
(0 Reviews)
0.0
rvente02

I have experience with .csv files and is a vb.net programmer.

$222 USD in 7 days
(0 Reviews)
0.0