Copying data from a webpage into Excel can often be a messy and laborious task. This was the case for one of my customers who prints data from a job search results on a daily basis. In this 3-part video series, I show my customer how to streamline their process when they do it manually, and the benefits of automating the process by creating a macro. There is no sound on the videos.
Copy Data from Website to Excel
In this video, I will manually copy more than a dozen pages of job data from the USAJOBS site to an Excel spreadsheet. This will result in nearly 1,200 rows of data. Unfortunately, the website does not provide a download or print button to help the process.
Manually Format the Data in Excel
Once the data has been downloaded, it must be formatted and rearranged. Depending on which team member performs the daily task (they take turns), the process can take 1-2 hours. I created this 6 minute video to provide each team member with the optimal steps to complete the process in minimal time. My hope is that if they follow these steps, they can the data ready to print in 20-30 minutes instead of 2 hours.
Using a Macro
I recorded this video to show the customer that using a macro, their entire formatting and rearranging process can be completed in seconds, not hours.