Find Jobs
Hire Freelancers

Create Excel Macro to Create New Products for Sku List

$2-8 USD / hour

In Progress
Posted about 8 years ago

$2-8 USD / hour

I have a master product list that we are constantly adding new products to. It's like 25k rows long. Kind of a pain to scroll thru all of it. I'd like to create a macro tool that will allow me to simplify the creation of new products. Basically cells connected to validation lists so that I can easily just type the letter "A" for example and see the word Angelfish populate. I'd like to have 6 columns with headers : Species, Common Name, Size, Lot, CAT (stands for Category), 6th column will be for a button. --Species will be a drop down validation list of all species we have for sale... --Common Name will have the name after the first comma [ , ] in the sku list. --Size : Sm | SMd | Md | MLg | Lg | XLg | XXLg | Jumbo | Show -- Lot Count: 2 Lot, 3 Lot, 4 Lot, 6 Lot, 8 Lot, 10 Lot, 12 Lot, 18 Lot, 20 Lot, 24 Lot -- CAT: DB-1, DB-2, FSSS1, FSSS2, ISS-1, ISS-2, FSS1, FSS2, FS1, FS2, TR-1, TR-2, FC-1, FC-2, CC-MI, CC-CL, BCL-SC, BCL-MC, FS-CF, FS-PP, FS-PEP, FS-iPET, FS-RN, FS-V20, WS-FR1, WS-FR2, CSS, GAS, Remove- The button will put the new product in the StockList Sheet according to other similarly named products. Before it does that, it will need to merge the options selected from the columns to create 1 complete product name. It will then add product to our master SKU excel. It also should add the product to our Master Specials Sheet. So it does 4 things. The CAT button is a validation list function we have the sends products from one master stocklist sheet to our daily specials sheet
Project ID: 9580080

About the project

14 proposals
Remote project
Active 8 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
hi. i made already template excel sheets for your project. please contact me to see these sheets. to attach file is not possible in this proposal input page. thank you.
$8 USD in 3 days
0.0 (0 reviews)
0.0
0.0
14 freelancers are bidding on average $7 USD/hour for this job
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 60 projects, almost 50+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$21 USD in 8 days
4.8 (51 reviews)
5.3
5.3
User Avatar
Hi there My name is Redouane I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you
$5 USD in 8 days
4.9 (59 reviews)
4.6
4.6
User Avatar
Hello, this kind of project is something I am searching for. I love working this sort of job and solving these Excel problems. I am proficient with Excel and VBA and macros and I would really enjoy in working on this project. Please contact me for more information.
$7 USD in 3 days
5.0 (11 reviews)
3.6
3.6
User Avatar
Hi, I can develop your excel macro for you. I can start immediately and have this done within one day (24 hours). I am very experienced both with excel and vbscript macros, and will have no problem completing this for you. Feel free to contact me to discuss the details of this project.
$5 USD in 8 days
5.0 (1 review)
1.9
1.9
User Avatar
Hello, I can do the taskin less time, and 100% accurate - I'm a Visual Basic programmer, I write programs in VB6 since 2007, in VB.Net since 2013. - Have long experience with MS-Excel (formulas & VBA macros). - Have long experience with winsock applications, FTP connections, math stuff & calculations, applications that works with files & folders, and creating mini-tools that automate tasks while working in background. - Experience with database based applications (MS-Access & SQL Server). - Accuracy and precision is one of my principles, also one of my best advantages. - Commitment to deliver tasks in time. I I'm looking forward to working with you, helping you to solve problems :) Please feel free to contact me to discuss any further details.
$8 USD in 10 days
3.9 (3 reviews)
1.8
1.8
User Avatar
Hi there! I am an advanced excel user and would be able to help you out with your request. I currently work for a digital marketing agency in London in the research & analysis department. I use excel on a daily basis to create customised reports, which require validation lists and macros among many other features. I would probably be able to get it done for you after aprox. 5 working days (due to other commitments). If you send me a copy of your excel files, i should be able to work on it straight away. Fortunately your brief is quite in-depth which will make it easier to work on it. Kind regards, Thuong
$7 USD in 12 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Our company makes a lasting impression. That is without a doubt excellent service that we can definitely provide with our Virtual Assistants, Customer Service Representatives, Email Supports, Data Encoders and so on. Our vision is to become the top outsourcing company in the Philippines the next 10 years. We have the right people on our team that has the values the company wants to build up with. We hope you can give us the chance to show what we can do.
$5 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
it will be a pleasure to work with you Im ready for this task
$5 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would definitely be the ideal candidate for this job as you can check on profile for my work experience where i perform a lot of data entry using excel and also generating reports. Hope i get to work with you on this project soon.
$6 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
As I am an IT Professional and interest in working Data Processing & Entry. Have working experience in various Data Processing, Entry & Analysis jobs. Lot of efforts are contributed towards automating different Data sets to process and provide useful analysis with respective to the different types of business process. Data Process & Analysis will be key success factor for any kind of business decision. Following are critical activities in taking this activities: 1.) Requirement understanding like what employer is expecting on this project. Finally, documenting scope and approvals from employer so that there is no confusion & time loss. 2.) Since 5 years doing research on the Data Processing & Analysis activities. By taking various data set types from web or manually created data sets, experimenting them to achieve right analysis report in enabling various crucial business decisions of different verticals. 3.) Will define various milestones as per requirements along with target time lines. This will enable employer tracking his out sourced activity. With this kind of tracking will control other activities which are dependent on this activity. Using available macro library or scripts or develop new macros or scripts according requirement will process the data in excel. These libraries are developed by me which can be useful to process the data quickly and accurately. 4.) Will help me in gaining knowledge in untapped areas. Thanks for the opportunity.
$5 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Elmsford, United States
4.8
70
Payment method verified
Member since Jun 10, 2013

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.