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.


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.


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.

Taidot: Visual Basic, Tietojenkäsittely, Excel, Microsoft Office

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Atlanta, United States

Projektin tunnus: #29478812

17 freelanceria on tarjonnut keskimäärin $19/tunti tähän työhön


Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in sam Lisää

$20 USD / tunti
(428 arvostelua)
(197 arvostelua)
(66 arvostelua)

Hi, I can build a MACRO to split copied string and convert data to specific format as you discibed. I have more experiences in Visual Basic, MS EXCEL and VBA. Offering many ideas and suggestions IF NEEDED Looking forwa Lisää

$20 USD / tunti
(28 arvostelua)

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start right away and complete it within a few hours. If Lisää

$15 USD / tunti
(23 arvostelua)

I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to per Lisää

$15 USD / tunti
(16 arvostelua)

HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I has done tons of projects similar to your requirement using VBA. I ca Lisää

$15 USD / tunti
(4 arvostelua)

Although I do not see an attachments, I have 25 years experience developing Excel, Access and VBA Scripts for a major computer corporation. I have reviewed your project and I can write a macro to perform reformatting Lisää

$20 USD / tunti
(3 arvostelua)

Hi - I have 15+ years working with excel and excel VBA creating reports, templates and data analysis. You can check my portfolio for sample work. Send me a message if you find me suitable. Thank you!

$20 USD / tunti
(1 arvostelu)

i knowledge of Excel, excel macro and visicul basic, c#. i can do things easly with programming. I'm mathmatician i solve problem even while sleeping

$20 USD / tunti
(0 arvostelua)

I Can Perfectly Help you With that. I am a professional Data Analyst And Excel expert holding years of experience in utilizing advance levl tools And Functions of Google Sheets & Excel (including VBA and macro) To Fina Lisää

$24 USD / tunti
(0 arvostelua)

Hi I read description and understand about work that needs to migrate wordpress website to other server. I will be able to do this quickly as required.

$18 USD / tunti
(0 arvostelua)

I can perform the task much before deadline and that too with full efficiency. knows advance microsoft office.

$20 USD / tunti
(0 arvostelua)

Hi, I have advanced skills in using excel VBA. I have programmed several templates for the organisation I work for. Please give me the assignment and only 24 hours to deliver what you need

$25 USD / tunti
(0 arvostelua)

I am an experienced data entry expert. I can deliver the project with in the time period. my work would be world class accurate. fast keying skills and sound knowledge of computer applications. I am a very energetic an Lisää

$20 USD / tunti
(0 arvostelua)

I have Hands on experience in creating Macro enabled workbook for automation. If interested I can work with you.

$16 USD / tunti
(0 arvostelua)

Greetings! Glad to inform you that I can assist on your project, we can negotiate the project for further instructions and requirements. Best regards.

$15 USD / tunti
(0 arvostelua)