Automate raw .csv data to a table

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

I have an business renting homes on Airbnb and want a clean, easy to use table to view the revenues data in. When I download the csv from Airbnb I have these issues:

-the date format is unreadable and needs a manual fix each time

-i use the sum function and have to manually pick the rows for each listing

It shouldn't be too difficult to do on VBA, low budget

Excel

Project ID: #17849857

About the project

2 proposals Remote project Active 5 years ago

Awarded to:

aubrey03

I am an Excel specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$25 USD in 1 day
(40 Reviews)
5.0