Kapalı

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, Veri İşleme, Excel, Microsoft Office

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Atlanta, United States

Proje NO: #29478812

Bu iş için 17 freelancer ortalamada $19/saat teklif veriyor

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

$20 USD / saat tutarından itibaren
(428 Değerlendirme)
8.3
(197 Değerlendirme)
6.9
(66 Değerlendirme)
6.8
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 Daha Fazla

$20 USD / saat tutarından itibaren
(28 Değerlendirme)
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 Daha Fazla

$15 USD / saat tutarından itibaren
(23 Değerlendirme)
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 Daha Fazla

$15 USD / saat tutarından itibaren
(16 Değerlendirme)
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 Daha Fazla

$15 USD / saat tutarından itibaren
(4 Değerlendirme)
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 Daha Fazla

$20 USD / saat tutarından itibaren
(3 Değerlendirme)
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 / saat tutarından itibaren
(1 Yorum)
0.9
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 / saat tutarından itibaren
(0 Değerlendirme)
0.0
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 Daha Fazla

$24 USD / saat tutarından itibaren
(0 Değerlendirme)
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 / saat tutarından itibaren
(0 Değerlendirme)
0.0
ishanms112002

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

$20 USD / saat tutarından itibaren
(0 Değerlendirme)
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 / saat tutarından itibaren
(0 Değerlendirme)
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 Daha Fazla

$20 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0
RKB22

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

$16 USD / saat tutarından itibaren
(0 Değerlendirme)
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 / saat tutarından itibaren
(0 Değerlendirme)
0.0