Macro To Clean & Format Data Copied From Website

Lezárva Kiadva: 3 évvel ezelőtt Kiszállításkor fizetve
Lezárva

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.

Visual Basic Adatfeldolgozás Excel Microsoft Office

Projektazonosító: #29478812

A projektről

17 ajánlat Távolról teljesíthető projekt Utoljára aktív: 2 évvel ezelőtt

17 szabadúszó tett átlagosan 19$/órás árajánlatot erre a munkára

schoudhary1553

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 Továbbiak

$20 USD / óra
(428 vélemény)
8.3
MMG2019

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 Továbbiak

$20 USD / óra
(28 vélemény)
4.6
MonisZafar

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 Továbbiak

$15 USD / óra
(23 vélemény)
4.7
Jayant222

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 Továbbiak

$15 USD / óra
(16 vélemény)
3.6
arunodaya123

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 Továbbiak

$15 USD / óra
(4 vélemény)
2.0
RTYSDAL

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 Továbbiak

$20 USD / óra
(3 vélemény)
1.8
LiAnOr

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 / óra
(1 Visszajelzés)
0.9
himansukumar1452

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 Továbbiak

$24 USD / óra
(0 vélemény)
0.0
ubvural

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 / óra
(0 vélemény)
0.0
joeannocena0417

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 / óra
(0 vélemény)
0.0
pradeep294294

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 / óra
(0 vélemény)
0.0
ishanms112002

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

$20 USD / óra
(0 vélemény)
0.0
Kiboma

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 / óra
(0 vélemény)
0.0
sanjeevboge84

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 Továbbiak

$20 USD / óra
(0 vélemény)
0.0
RKB22

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

$16 USD / óra
(0 vélemény)
0.0