Macro To Clean & Format Data Copied From Website
$15-25 USD / óra
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.
Projektazonosító: #29478812
A projektről
17 szabadúszó tett átlagosan 19$/órás árajánlatot erre a munkára
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
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
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
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!
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
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
Greetings! Glad to inform you that I can assist on your project, we can negotiate the project for further instructions and requirements. Best regards.
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.
I can perform the task much before deadline and that too with full efficiency. knows advance microsoft office.
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
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
I have Hands on experience in creating Macro enabled workbook for automation. If interested I can work with you.