Find Jobs
Hire Freelancers

Batch operations on Excel files

$100-120 USD

In Progress
Posted about 12 years ago

$100-120 USD

Paid on delivery
I would like to do some 'coloring' of Excel columns based on certain criteria, as well as some multiple sortings etc. Please read the short yet detailed description. ## Deliverables I am working on Excel files and have been wasting considerable time 'coloring' the columns of these Excel files based on certain criteria, not for fun, of course, but because I need to color them to perform some special sortings there afterwards. What I would like to do is 'automate' that i.e designate columns, say column AE, then designate conditions for it 'i.e. all contents less than 0', or 'all contents equal to 1' or 'all contents greater than A and smaller than B' etc etc and finally choose a color in Excel to color each with. Note: You must also include a 'flag' (let's say checkbox) Inclusive/Non-Inclusive for the arithmetic values I will be inputting. I will be able to input conditions for multiple columns, one by one, and all will be executed together when the program runs. This will be a program with 'default settings memory' i.e. I am doing this to multiple files every day, so I will run the program many times daily without having to re-designate colors, conditions etc (i.e. 'rules') every time. There will also be a function 'Copy in Column This the colors (or values, I will be able to designate which or even BOTH) of column That'. Furthermore there will also be a command 'erase all rows whose value on column <this> will equal (or non-equal) <that>'. Lastly I specify a multiple sorting criteria in Excel as a 'bundle', like Sort column J Values Largest-to-Shortest and Sort column V Cell Color (this color) on top and Sort column AH Values 'Smallest-to-Largest' In order to do that, I have to open all my Excel files one by one and perform that sorting. From now on I wish to do it from 'outside' Excel in this new program, by defining the conditions there, selecting an .xlsx file, pressing some 'sort' button and have it done. Note: If some column - say column AH in the above example - contains special characters, like '-' or 'Just' or whatever, Excel's specifications shall be observed, i.e. the special characters will be on top, and then the numerics will follow. For example, try to sort column AH as Largest-To-Smallest in '[login to view URL]' of my attached files and you shall see what I mean. All aforementioned processes will be performed either on a single Excel file - as I mentioned so far - which I will designate with some 'Browse' button OR on a _folder_ containing many Excels like this, one after the other. In other words, I will be able to designate a folder instead of a single file and everything will be performed on this folder's contents, one by one, as 'batch' processing. The User Interface should be straightforward to use. The program must run on any Windows XP operating environment or above. I would prefer an .exe file, mainly for speed purposes, but perhaps a VBA one will do as well. I am attaching a sample Excel like the ones I am using every day in order for you to inspect it, if you wish, both with as well as without colors and sortings.
Project ID: 2733839

About the project

21 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $87 USD for this job
User Avatar
See private message.
$100.30 USD in 5 days
4.9 (62 reviews)
6.3
6.3
User Avatar
See private message.
$102 USD in 5 days
4.4 (37 reviews)
5.9
5.9
User Avatar
See private message.
$100.30 USD in 5 days
4.8 (25 reviews)
5.2
5.2
User Avatar
See private message.
$102 USD in 5 days
4.9 (40 reviews)
4.5
4.5
User Avatar
See private message.
$42.50 USD in 5 days
5.0 (68 reviews)
4.6
4.6
User Avatar
See private message.
$93.50 USD in 5 days
4.7 (30 reviews)
4.4
4.4
User Avatar
See private message.
$84.80 USD in 5 days
4.9 (20 reviews)
3.9
3.9
User Avatar
See private message.
$90.10 USD in 5 days
5.0 (5 reviews)
3.7
3.7
User Avatar
See private message.
$100.30 USD in 5 days
5.0 (1 review)
1.6
1.6
User Avatar
See private message.
$70.55 USD in 5 days
5.0 (1 review)
0.0
0.0
User Avatar
See private message.
$50.15 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$80.75 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$80.75 USD in 5 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$100.30 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$102 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$84.15 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$102 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$102 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$76.50 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$85 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of
5.0
19
Member since Sep 15, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.