Excel Macro To Clean & Format Data Copied From Website

Đã Đóng Đã đăng vào 3 năm trước Thanh toán khi bàn giao
Đã Đóng Thanh toán khi bàn giao

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 Excel Excel Macros Data Cleansing Excel VBA

ID dự án: #29478780

Về dự án

30 đề xuất Dự án từ xa 3 năm trước đang mở

30 freelancer chào giá trung bình$131 cho công việc này

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 Thêm

$150 USD trong 3 ngày
(573 Nhận xét)
8.5
Akib2020

✅ Expert on Advanced Excel ✅ Hi there! I can build a script for clean txt data and input excel sheet correct format using vba, macro, nested formula with 100% accuracy. I'm expert on vba, macro, data cleaning, duplicat Thêm

$50 USD trong 1 ngày
(117 Nhận xét)
7.1
finecodervw

Hi, As I understand you would like to have Excel macro to clean and format the data that you would be copying from the website. The project description mentions about attachment but the same is not available. Please Thêm

$90 USD trong 3 ngày
(205 Nhận xét)
6.9
narsim3128

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed pr Thêm

$100 USD trong 4 ngày
(73 Nhận xét)
6.1
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 Thêm

$100 USD trong 2 ngày
(29 Nhận xét)
4.6
fchorley99

Hello, I'm not sure this would require a macro. The changes and formatting of data could be done with simple formulae, cell formatting and some named ranges. This means, e.g., copy from the website, paste into a spec Thêm

$45 USD trong 4 ngày
(5 Nhận xét)
4.3
nadjasalewski

Hi there, This sounds like an interesting project and I would like to write the macro for you. With an accounting background and over 10 years of experience in working with Excel (with a focus on the automation and str Thêm

$200 USD trong 7 ngày
(8 Nhận xét)
4.4
pmshilwant9

Hi, I would like you to work on your project. I am having around 10+ years of experience in this domain. I am an automation Specialist in BI domain (BI reporting, Automation and Visualization). Can do programming i Thêm

$150 USD trong 2 ngày
(9 Nhận xét)
3.1
shossainsayem

Hi, I have gone through your project proposal in detail. I understand the nature of your work 100%. I am interested on this project. I am freelancing with Fiverr, Freelancer and Upwork since 2019. I will start worki Thêm

$278 USD trong 1 ngày
(1 Nhận xét)
1.3
apatil101

I am expert in data analysis using Excel, VBA and Power Bi. I have professional experience of working with Excel/Acess/VBA/Power Bi for more than 20 years. Speed and accuracy are my strengths. I will complete your proj Thêm

$140 USD trong 7 ngày
(0 Nhận xét)
0.0
adelusidemola8

We are professionals and have experience in Excel with more than 8years experience in Pdf to excel, Combine multiple sheet to master sheet, VBA excel, Address Shorting, Remove duplicate, Email list cleaning, Userform Thêm

$30 USD trong 1 ngày
(0 Nhận xét)
0.0
Mani5549147

iam server admin and have 8year's experience in mailing server setup and campaign management. let's chat here..

$120 USD trong 5 ngày
(0 Nhận xét)
0.0
pojiejopie

Hi Sir, I'm Fauzi, I've 5+ years of experience in excel VBA programming. I can help you to create a macro to pull data from the website and re-format the data into table as per your like. I can do a lot of stuff with Thêm

$30 USD trong 1 ngày
(0 Nhận xét)
0.0
aashok207

I have 8 years of experience in automation using VBA & RPA tools. I'm have sound knowledge in automation and good at logics behind complex problems. Give me a chance to do this project, then you will not leave for upco Thêm

$140 USD trong 7 ngày
(0 Nhận xét)
0.0
saleemjee911

Hi there I am an Excel VBA expert, noting to explain just loyalty to my work, if you don't like my work just ask i will return the money.

$89 USD trong 5 ngày
(0 Nhận xét)
0.0
bhattineeraj123

I am good at vba i can do your project if you are interested we can go forward i will provide tge projects in two phases

$140 USD trong 7 ngày
(0 Nhận xét)
0.0
duggu124

Dear employer, I have thoroughly read the project details and understood what is being required. I have experience in this type of project. I can assure you that I can do this project. If you want me to work on this pr Thêm

$30 USD trong 3 ngày
(0 Nhận xét)
0.0
karthik13689

Data cleansing, Data segregation and Data consolidation are my day to day work for more than a Decade now and I’m very well versed with the assignment you’ve mentioned.

$30 USD trong 5 ngày
(0 Nhận xét)
0.0