sedang Berlangsung

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

Keahlian: Entri Data, Pemrosesan Data, Excel, PHP, Visual Basic

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 0 ulasan ) Manunda, Australia

ID Proyek: #17309100

15 freelancer menawar dengan rata-rata $84 untuk pekerjaan ini


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 Lebih banyak

$30 AUD dalam 0 hari
(596 Ulasan)

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 Lebih banyak

$150 AUD dalam 3 hari
(281 Ulasan)

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 Lebih banyak

$55 AUD dalam 3 hari
(61 Ulasan)
$30 AUD dalam 1 hari
(37 Ulasan)
$25 AUD dalam 1 hari
(6 Ulasan)

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

$25 AUD dalam 1 hari
(4 Ulasan)

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 Lebih banyak

$25 AUD dalam 1 hari
(3 Ulasan)

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] Lebih banyak

$25 AUD dalam 1 hari
(0 Ulasan)

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 Lebih banyak

$15 AUD dalam 1 hari
(0 Ulasan)
$30 AUD dalam 1 hari
(0 Ulasan)

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 Lebih banyak

$444 AUD dalam 6 hari
(0 Ulasan)
$25 AUD dalam 1 hari
(0 Ulasan)
$150 AUD dalam 7 hari
(0 Ulasan)

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 dalam 2 hari
(0 Ulasan)
$10 AUD dalam 3 hari
(0 Ulasan)