Create Excel Macro to Create New Products for Sku List

$2-8 USD / hour

En cours

Publié

il y a environ 8 ans

$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

Excel

Visual Basic

N° de projet : 9580080

Concernant le projet

14 propositions

Projet à distance

Actif à il y a 8 ans

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

Décerné à :

@powerinexcel

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 en 3 jours

0,0

(0 commentaires)

0,0

14 freelances proposent en moyenne $7 USD/heure pour ce travail

@kevivu

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 en 8 jours

4,8

(51 commentaires)

5,3

@redouaneaberdin

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 en 8 jours

4,9

(59 commentaires)

4,6

@vlayausa

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 en 3 jours

5,0

(11 commentaires)

3,6

@abstudios

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 en 8 jours

5,0

(1 commentaire)

1,9

@GeniuSBraiN

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 en 10 jours

3,9

(3 commentaires)

1,8

@thuong1990

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 en 12 jours

0,0

(0 commentaires)

0,0

@djdomingo13

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 en 3 jours

0,0

(0 commentaires)

0,0

@Dabvid

it will be a pleasure to work with you Im ready for this task

$5 USD en 5 jours

0,0

(0 commentaires)

0,0

@andrea1255

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 en 3 jours

0,0

(0 commentaires)

0,0

@janasuresh2017

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 en 3 jours