Find Jobs
Hire Freelancers

Create Simple Add-in / Macro Rules for Excel

$30-5000 USD

Cancelled
Posted over 15 years ago

$30-5000 USD

Paid on delivery
I need someone to create a ? very simple add-in for excel 2007, or create Macro rules that will answer my following needs: 1) Group keywords according to parameters? I provide. 2) Add digits/characters automatically at the End/Beginning of phrases. 3) Shortcut rule for a combination of copy/paste? rows + find & replace words. and a few more.. ## Deliverables Hello, I need someone to create a? very simple add-in for excel 2007, or create Macro rules that will answer my following needs: 1)? I have a group of, say, 225 words ??" I want to group them according to parameters I give, such as ??" all keywords that have "red" & "nice" in them ??" to be on top. All keywords that have "green" and "Ugly" in them ??" to go to another group. Keywords that can answer 2 quarries ??"to another group etc.. etc… So if I inserted all keywords into one column (225 cells) ??" I want to reorganize them so that on top I will have all keywords that answer my first grouping parameters, then I will have the second group, etc etc.. ??" without having the same keyword ??" in two or more different groups. 2)? I need to be able to add digits/Characters in the end/beginning of a list of urls/phrases ??" automatically. E.g. ??" I give: [[login to view URL]][1] I copy it? to 150 rows, and the script adds numbers in increasing order, so I get: "[[login to view URL]][2]", "[[login to view URL]][3]", etc… etc… 3)? I want to have a certain rule that will do all the following in 1 click: select (e.g.) rows 1-160, then copy & paste them in the next rows underneath (rows 161 and downwards), then find & replace all the words (e.g.) "Red" with the words "Blue" in that new group of rows, then do the same thing again, but this time replace "Blue" with "Yellow", etc… etc… 4)? Another shortcut rule I need: I have a list of words in column A (164 cells length). I insert "Free Shipping" in column B ??" Cell 1. I want this phrase to copy itself down ??" to all rows ??" so that it will know to stop when there are no parameters on the cells to the left. Currently I have to manually copy and highlight all cells all the way down ??" until I get to the last relevant row. 5)? With one press of a button I want Excel to automatically copy one or more columns (e.g.? all 224 rows downwards) excluding row number 1 (where I have the headers of the columns). I may need more rules as I progress with my project so am really looking to find 1 skillful Programmer/Excel Pro ??" to help me with all my future needs. Thanks
Project ID: 3439000

About the project

7 proposals
Remote project
Active 15 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
7 freelancers are bidding on average $86 USD for this job
User Avatar
See private message.
$51 USD in 14 days
5.0 (122 reviews)
8.3
8.3
User Avatar
See private message.
$170 USD in 14 days
5.0 (199 reviews)
6.8
6.8
User Avatar
See private message.
$40.80 USD in 14 days
5.0 (83 reviews)
5.2
5.2
User Avatar
See private message.
$25.50 USD in 14 days
5.0 (14 reviews)
3.9
3.9
User Avatar
See private message.
$212.50 USD in 14 days
5.0 (1 review)
3.2
3.2
User Avatar
See private message.
$15.30 USD in 14 days
5.0 (7 reviews)
2.8
2.8
User Avatar
See private message.
$85 USD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ISRAEL
Israel
5.0
74
Member since Sep 4, 2007

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.