Find Jobs
Hire Freelancers

Need EXCEL Macro to replace our (ISNUMBER(SEARCH Formula has become TOO BIG

$10-30 USD

Completed
Posted about 4 years ago

$10-30 USD

Paid on delivery
We are good with formulas, but not macros... need someone to write excel macro wkbk has headers need to search for value(text) in attribute ItemDescription if search value found places our custom result in attribute Brand Name if no matching search term value found result is Everything Else example: ItemDescription attribute, cell contains Day Break (search term: Day Break) Result places Day Break Illusion in Brand Name attribute (result: Day Break Illusion) will send sheet of search term and corresponding result if found, might be 200 search terms could be 400 not sure yet. will list all in sheet for YOUR reference. Please let us know if you understand what we are looking for in your message to get our attention, reference Day Break Illusion example. we were going to do this with a (ISNUMBER(SEARCH formula, but can only nest 64 It is suggested online to use a table but that seems clunky for us, we know nothing about tables but would consider if easier We are not currently calling anything else in the sheet by attribute, only using cell references in our formula, hopefully not an issue. willing to place this macro in its own wkbk which we would use only when needed. Tagged as Excel VBA- believe that is for macros?
Project ID: 23985516

About the project

28 proposals
Remote project
Active 4 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
Awarded to:
User Avatar
Hello, i believe i can code this for you. If possible, would you mind attaching a sample sheet, so i can see an actual sample of what needs to be done. I believe i can code this in less than an hour, and i am available to start immediately. Thanks, Milan
$20 USD in 1 day
5.0 (588 reviews)
7.2
7.2
28 freelancers are bidding on average $25 USD for this job
User Avatar
Hello, I’m an Excel expert and I would like to help you with your formula. Please send me a message so that we can discuss more.
$30 USD in 1 day
4.9 (444 reviews)
7.8
7.8
User Avatar
Greetings! I can write a macro for searching using a list of terms and returning appropriate results. The solution would be such that the list of search terms can be dynamic (number of search terms can vary over time). Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the files - I would come up with a macro as required. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$30 USD in 1 day
5.0 (229 reviews)
7.0
7.0
User Avatar
Hello, I would like to work on your project. I have a great experience using excel macros / VBA, data formatting and data manipulation in excel. I had many similar jobs before. In order to complete this work, I will need sample data with some records. Let's discuss further details on chat. Regards.
$20 USD in 1 day
5.0 (142 reviews)
6.6
6.6
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.
$35 USD in 1 day
5.0 (142 reviews)
6.7
6.7
User Avatar
Hello, I am an independent, experienced excel expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards a Rina B.
$30 USD in 1 day
5.0 (122 reviews)
6.5
6.5
User Avatar
Hi, I can develop a macro to search any text in excel sheet and take action accordingly. I am experienced Data Analyst and Macro Developer and have done many similar projects. I have excellent knowledge and experience of Manipulating Data in Multiple Sheets and Creating Reports. So, can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra
$30 USD in 1 day
4.8 (111 reviews)
5.9
5.9
User Avatar
 Sir,      I am well versed in these kind of jobs and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. with thanks and regards 
$29 USD in 1 day
4.7 (104 reviews)
6.2
6.2
User Avatar
I can use your list of search terms (upto 10000) ans search them in item description once found, predefined result for that search term will be generated in brand name (result). I am sure you must have got an idea of my understanding of the requirement, lets discuss this in detail in chat. I am full time freelancer with postgraduate having more than 6 years of experience in advanced excel based tools, VBA automation, dynamic dashboards, google spreadsheets, google scripting, financial modeling, and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automation tools for Ernst & Young and Landmark Group also. You can get your work done here with highest quality at lowest price. No payment required in advance, please pay me once the job is 100% complete. . Please initiate a chat so we can discuss on this as I may have some questions. Looking forward to work with you
$60 USD in 1 day
4.9 (43 reviews)
5.7
5.7
User Avatar
Hi, I am interested in working on the task. I have more than 5 years of experience working with Excel Macros. I can get this done successfully. Please share files. Looking forward to hear from you. Best Regards, Akila.K
$30 USD in 1 day
5.0 (53 reviews)
5.7
5.7
User Avatar
I'd like to be considered for your request. I am a data guy with a strong background developing several excel tools including vba automation and complex formulas and functions applied in excel and I can assure quality and accuracy in a short time based on your request. For more than 10 years i've worked on different sets of files having to deal with a lot of complex projects. I have a deep passion to finish in time every project that i am involved in. You can see my profile for better understanding what i was involved with. I highly evaluate professionalism and hold my self strictly accountable to fulfill my client need. I aim to form a great working relationship. Thank you for your consideration. Martin
$25 USD in 1 day
5.0 (37 reviews)
4.9
4.9
User Avatar
Hi there, I am available to complete your work ASAP. I am an expert in data processing, excel, excel VBA, and visual basic. Please contact me for more information. Thanks in advance.
$20 USD in 1 day
4.8 (30 reviews)
4.5
4.5
User Avatar
Hi! VBA is for macros yes. What you're asking is pretty much clear. I don't think there's any need for questions to clarify really. You want: IF (NOT IS_ERROR(ROW_X=FOUND(x,RNG_XY,COL_X) ))THEN ASSGN(RNG_Y,(Y=REL_X(ROW_X,RNG_XY,COL_Y)) ELSE ASSGN(RNG_Y,NOMATCH_VALUE) END IF Where FOUND searches for presence of 'x' in RNG_XY->columns(COL_X) as full string, same order of words, space or prep_char limited, and NOMATCH_VALUE from your exampel is 'Everthing Else'. Did I get your point right? What you did not mention though is very one important aspect though - it's gonna run on WIndows or Mac Excel, because VBA capabilities are not the same between the two. Kind Regards, Dobri PS: It can still be achieved the same result without using macros and without hittin 'nesting level' limits as well.
$15 USD in 0 day
5.0 (8 reviews)
3.4
3.4
User Avatar
Greetings, Through the most part of my 35+ years career, I have used Excel extensively to manage the programs / projects / actions and the reporting requirements. Normalized/cleaned up lot of data, collected from various sources and made it easily usable using Excel. Provided numerous solutions using Excel in the area of Budgets, Actuals, Revenue Projection, Billing, Gross margins, Project Estimates / Plan / Monitoring / Reporting, Performance Assessments, Resource Management, Timesheets etc. These required me to use lot of functions & formulas and very innovative Pivot table features. Keen to take up this assignment as I love working with Excel and will add value using my experience. Please refer to my portfolio "Excel Pivots and Charts". If I understand it correctly: - You have large table containing item description - There are 200-400 keywords - If you find any of these in the item description, populate Brand Name attribute - I have the solution for this ready The problem is simple and can be solved quickly and I commit to support you for 1 hour full, even if the problem is solved in 5-10 minutes. if proposed terms are the problem, we can discuss the same. Thank you for taking the time to read my proposal. Warm Regards
$23 USD in 7 days
5.0 (2 reviews)
2.5
2.5
User Avatar
Hello, Thank you for your interest in my profile. I am ready to automate your task using VBA (macros). best regards, Dima
$20 USD in 3 days
5.0 (1 review)
1.0
1.0
User Avatar
Good Day Madame / Sir , I believe I am qualified for this position & wants to have this project. I am a fast learner & I am a good typist. I am currently working in the furniture industry, OS I have knowledge regarding with this one. Looking forward to talk to you. Thank you
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
you can belive me, otherwise i do not have any explanation to you for my work. as soon as possible i done my work.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Respected Recruiter, I read with interest your job posting and I would like to apply to this job. As my profile indicates, I posses more than six years of working as a VBA developer in a company. I have developed similar tools in Excel (importing/exporting data, automation, create PowerPoint files, Word or Outlook items, chart creation, import/export data to SQL, etc). I'm new to this platform but I can share client feedback and reviews on Upwork platform, that I'm using for over 2 years. Looking forward to discuss the details of your available position. Sincerely, Bogdan Cristescu
$20 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I has to work for you and I want review and ratings I started working with Microsoft more than 2 year so I think I must qualified for this job
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very hardworking and versatile...plzz give me chance. Relevant Skills and Experience I have done data entry work, I can do this very well.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there! I think I might just have the solution for your current problem. I did some similar Excel spreadsheet before and I had coded some Macros to automate the search of keywords and output of the results. I would love to share my solution with you and appreciate if we could collaborate further. I may appear somewhat as new user in Freelancer but I got a really good actual experience in dealing with similar Excel/VBA problems. I look forward to hear from you soon. Cheers!
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Rockford, United States
5.0
3
Payment method verified
Member since Jan 4, 2019

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.