Completed

Macro To Clean & Format Data Copied From Website

My local YMCA has started posting their schedules online. I am interested in getting the Pool Schedule data from the site and into Excel so that I can read it in a tabular format. I would like to accomplish this using an Excel Macro that you build.

REQUIREMENTS

I want to be able to navigate to their website, copy the data from the site using CONTROL+A, paste it into Excel (as values), and then be able to run a macro that spits out cleanly formatted data.

The end product should:

-Convert the YMCA's dates into "Long Date" format in Excel.

-Convert the times into Microsoft Excel times, and put them into "Start Time" and "End Time" columns.

-Return a neatly formatted Microsoft Excel Table of the data in the columns that I specify in the example Excel document.

-Work for any time into the future as long as the format remains the same.

INCLUDED FILES

I am including some sample data in .TXT format, along with an example of what I want the end product to look like in Excel. The Notepad file also includes a link to the site itself and instructions for how to navigate to the pool schedule.

Skills: Excel, Data Processing, Visual Basic, Microsoft Office

See more: data collection from website, data entry from website form to ms excel spreadsheet, data extract from website, we are an e-commerce startup and require a data entry professional to enter product data into the website, we are an ecommerce startup and require a data entry professional to enter product data into the website, data entry from website to excel, project data entry from website, data scraping from website software, data entry from website, scrap data manually from website, how to clean up data in excel, how to copy php source code from website, macro to clean up data in excel, how to download protected pdf file from website, how to clean missing data in spss, how to clean an oil painting from cigarette smoke, data mining from website, macro to extract specific data from excel, how to clean large data sets, how to clean spss data of outlier entries

About the Employer:
( 0 reviews ) United States

Project ID: #29478754

Awarded to:

Akib2020

✅ Expert on Advanced Excel ✅ Hi there! Checked: Attached txt & excel file I can write macro for clean data and input correct excel format with 100% accuracy. I'm expert on vba, macro, data cleaning, power query, nested More

$40 USD in 1 day
(52 Reviews)
5.3

3 freelancers are bidding on average $32 for this job

JohnRikz

Hello will create a macro that (WHEN THE RUN BUTTON IS CLICKED) pastes as value starting from a specific cell changes the date format changes to times into a recognized excel time formats as needed can we discuss? More

$45 USD in 2 days
(56 Reviews)
5.1
TopWritingGuru

I am willing to help you Macro To Clean & Format Data Copied From Website this project. I will deliver this work at very low price. My name is Rabia Faisal, I am working in the writing industry since 2011. In this tim More

$10 USD in 1 day
(1 Review)
1.2