In Progress

Automate repetitive task

Project to automate excel spreadsheet initially using Visual Basic and excel macros to

From Website [login to view URL]

1 Select date required (usually next day or following day)(please note the list is only available on a short term future basis only depending on sites database updates) ie daily.

2 Select runner list with cursor

3 With cursor and to cut and paste hold cursor immediately adjacent first name to select

Horse Race Tab WT BP

(Only this information)

4 Scroll down to capture entire list

5 Ctrl C to copy

6 Open new excel workbook

7 Paste list data to first 5 columns

8 Select entire list and cancel formatting and hyperlinks

9 Insert 2 columns to left of Race column (To allow inclusion of additional data from second list)

10 Scroll to bottom of list

11 At bottom of list copy and paste second list from local drive(example attached separately)

12 Sort list alphabetically (Column A)

13 Apply conditional formatting for duplicate entries using colour

14 Sort entries by colour to top of worksheet

15 Combine duplicate entries (cut and paste) to one line for each entry (note: on some days an individual horse may appear for 2 or sometimes even 3 separate races (different races or locations)) and may need to be copied and pasted twice. This is important as the horse may be nominated for separate race meetings and will not be “scratched” until race morning.

16 Delete balance of non-required list

17 Insert column to left of date column

18 Cut and paste TAB no’s. to this new column

19 Use the empty column (f) for each entered horse’s race times from the following web site (needs to be formatted as number)depending on location

20 Extract data for race times from

[login to view URL]

(done manually at present)

21 Sort into race time numerically

22 Format for further analysis

Skills: Data Entry, Data Processing, Excel, PHP, Visual Basic

See more: windows 10 automation, automate tasks in windows 10, automate windows tasks with python, windows automation tools, task automation definition, windows automation scripting, robotask, pc automation software, wordpress site book this project 6 days, 16 hours left OPEN Bids 137 Avg Bid (AUD) $1051 Project Budget (AUD) $750 - $15, Configure PFSense Firewall to allow OpenVPN clients to access local LAN, convert quark 9 to indesign, 9 to 5 mac, 9 to 5 jobs hiring, ielts writing task 1 band 9, local programmer to hire, local artist to do facial drawings for hire portland oregon area, automate some task 2, automate some task -- 2, automate repetitive, repetitive task openerp

About the Employer:
( 0 reviews ) Manunda, Australia

Project ID: #17309100

15 freelancers are bidding on average $84 for this job

jaylancer43

Hello Sir, Good Day ! To being with, the budget of the overall job to be done is no less than 300 AUD but I just put a placeholder to respect your set budget here, and in case if you are interested in increasing the More

$30 AUD in 0 days
(596 Reviews)
8.3
schoudhary1553

Hi there..... Warm Greetings We came along with your request for Automate repetitive task and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have profe More

$150 AUD in 3 days
(281 Reviews)
7.6
prabakarm23

Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook, PDF& Text files, MS Access and SQL Ser More

$55 AUD in 3 days
(61 Reviews)
5.1
$30 AUD in 1 day
(37 Reviews)
4.6
$25 AUD in 1 day
(6 Reviews)
2.5
Mokshith30

hi i am vba developer.. expertised in vba macros & web scraping .. i can scrape any website either static or dynamic also... thankyou

$25 AUD in 1 day
(4 Reviews)
2.2
vermadeepak77

Hi, I have been working on automation for long and have developed tools for it. Since your work involves automation of excel tasks so I can help you out in this. Kindly share more details for the work. Thanks Dee More

$25 AUD in 1 day
(3 Reviews)
1.3
Silky27

Hello, hope you are doing great. I can do this project with the titled:Automate repetitive taskI have complete expertise inData Entry, Data Processing, Excel, PHP, Visual Basic Additional Files: Current [login to view URL] More

$25 AUD in 1 day
(0 Reviews)
0.0
barunsamanta87

Hello, I got your requirements. I have the expertise to implement any design you ask for .The site will be mobile responsive, SEO friendly and conversion-centric etc.etc... Please see our previous work exampl More

$15 AUD in 1 day
(0 Reviews)
0.0
$30 AUD in 1 day
(0 Reviews)
0.0
madhuritha

I well understood the requirement. Basically you wanted to mark the Current blackbookers on next day race and want easy selection them for betting. I'll do this for you. I'm a computer engineer with excellent analy More

$444 AUD in 6 days
(0 Reviews)
0.0
$25 AUD in 1 day
(0 Reviews)
0.0
$150 AUD in 7 days
(0 Reviews)
0.0
waosisi

Professional team, good at machine learning and big data analysis, there are former big data analysts of aliyun among the team members, hoping to help you

$222 AUD in 2 days
(0 Reviews)
0.0
$10 AUD in 3 days
(0 Reviews)
0.0