Kapalı

Excel 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.

Beceriler: Visual Basic, Excel, Excel Macros, Data Cleansing, Excel VBA

Daha fazlasını gör: data entry from website form to ms excel spreadsheet, data entry from website to excel, excel macro to extract data from webpage, excel macro to get data from website, excel macro to copy rows from one sheet to another based on condition, excel macro to copy data from one sheet to another based on criteria, excel macro to copy data from one sheet to another based on date, excel macro to copy and paste from one worksheet to another, excel macro to search and display data, excel macro to open another workbook and copy data, how to clean up data in excel, macro to clean up data in excel, excel macro to pull data from jira, excel macro to extract data from a table, macro to extract specific data from excel, excel macro to append data from multiple sheets, excel macro to populate table from data, excel macro to copy data from multiple sheets into one sheet, excel macro to extract data from multiple excel files, excel macro to import data from website

İşveren Hakkında:
( 1 değerlendirme ) United States

Proje NO: #29478780

Bu iş için 33 freelancer ortalamada $127 teklif veriyor

(823 Değerlendirme)
8.8
(245 Değerlendirme)
8.0
(1003 Değerlendirme)
8.2
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 Daha Fazla

$150 USD in 3 gün içinde
(415 Değerlendirme)
8.2
P0L

(472 Değerlendirme)
8.0
(301 Değerlendirme)
7.3
(204 Değerlendirme)
6.9
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 Daha Fazla

$90 USD in 3 gün içinde
(133 Değerlendirme)
6.5
wsh2

* MsEXCEL Business programming and database expert. American English is my first and only language. USMC combat veteran. Note: Can have MsEXCEL automate the internet copy/paste. At your earliest convenience, please Daha Fazla

$189 USD in 7 gün içinde
(56 Değerlendirme)
6.5
Sercho56

Hi, I am an Australian software developer with significant experience in developing customised web-scraping application in Excel. I understand your desired solution, however I will first examine whether it is possible Daha Fazla

$120 USD in 3 gün içinde
(35 Değerlendirme)
5.9
(104 Değerlendirme)
5.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 Daha Fazla

$100 USD in 4 gün içinde
(65 Değerlendirme)
6.0
swarnali2017

Hi, i am very much interested to complete this project. I have completed similar type of [login to view URL] can see my portfolio. Therefore, looking forward to hearing from you.

$80 USD in 3 gün içinde
(32 Değerlendirme)
5.4
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(55 Değerlendirme)
5.4
(7 Değerlendirme)
4.6
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 Daha Fazla

$200 USD in 7 gün içinde
(5 Değerlendirme)
3.7
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 Daha Fazla

$45 USD in 4 gün içinde
(3 Değerlendirme)
3.8
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 Daha Fazla

$100 USD in 2 gün içinde
(16 Değerlendirme)
3.6
ravim211071

hi there I am an expert in Excel VBA and excel automation. I can create excel macro and userform that will copy data from website and format same data as per your requirements. I am sure that I can complete your pro Daha Fazla

$111 USD in 3 gün içinde
(8 Değerlendirme)
2.9
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
1.4