Find Jobs
Hire Freelancers

Update Excel Macro Buttons

$2-8 USD / hour

Annulleret
Slået op over 8 år siden

$2-8 USD / hour

I have an excel macro that I need to work on. This is Urgent, and needs to be completed ASAP. First part of task involves making some change to the sheet called Specials. The button called Save Stock List for Web currently creates a sheet called Union_Sheet1 which is formatted for our PHPExcel importer to understand. I need to add corresponding SKUS numbers for our products to COLUMN E on the Union_Sheet1 output. The skus is what our invoicing program uses to determine the product. All products skus are in the SKU sheet. Product names are all matching in the SKU sheet and the StockList sheet. That's how you would make the connection in excel, by name. So if a product is chosen, the corresponding sku for the product needs to be on our upload sheet. Our import tool is currently coded to see the SKUS in the following column for the Specials sheet. E - SKU Second part of task, is on sheet StockList. That sheet has button which looks at all the ADD|DEL columns. Click on a blank cell LEFT of a product or ABOVE a bolded title section in the Add|DEL column. From the drop down, select ADD on any of the products then click on Stock List Generator button. Currently, the sheet it creates makes a 3 column export. I need to add SKUS for the products to this export. Our import tool is currently coded to see the skus in the following column for the Stock List sheet. D - SKU for product column 1 E - SKU for product column 2 F - SKU for product column 3 Third and final task is sort of two parts. Part A, you will modify the Stock List for Web button in the Specials sheet. Instead of it just creating a sheet called "Union_Sheet1" , I need it to create a NEW excel sheet called "Updated Weekly Stock List" with the 4 sheets called [ Union_Sheet1 | Stock List (the output) | Dry| WYSIWYG] Part B, is on the export of WYSIWYG, it needs to add in Column G on WYSIWYG a generic/default SKU number on the output so our invoice program can understand the products. Final Task is to take the button on Sheet 1 called create "Stock list for Web" and change it. I am working with Excel 2011 on Mac, but this file will be run on Windows 8-10 pcs with Windows Excel 2010. Just letting you know cause I know the libraries sometimes mess things up for macros and stuff. I will test the file on the pc it will be run on final delivery. This is a rather urgent project so please ONLY apply if you are available to start working immediately, and can complete ASAP. Thank you for your time.
Projekt-ID: 9366199

Om projektet

21 forslag
Projekt på afstand
Aktiv 8 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
21 freelancere byder i gennemsnit $7 USD/time på dette job
Brug Avatar.
Hi, I m an Excel/VBA expert. Your 3 stps are well defined but with the Excel file it will be more clear. I can start now and finish today. Thanks
$6 USD på 5 dage
5,0 (338 anmeldelser)
7,9
7,9
Brug Avatar.
I can do it for you quickly and exactly .
$10 USD på 10 dage
4,9 (135 anmeldelser)
7,2
7,2
Brug 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 på 8 dage
4,9 (117 anmeldelser)
6,2
6,2
Brug Avatar.
Thank you for posting this project I will be able to do this work.......................................................
$5 USD på 3 dage
5,0 (85 anmeldelser)
5,8
5,8
Brug Avatar.
Hi There, Hope you are doing well. Thanks for the requirement. We have gone through your description and we are confident to deliver you best solution. Your Goal of the project and your requirement is very clear to us. Looking forward to hear back from you and maintain a long term relationship. Cheers! Subrata R.
$8 USD på 30 dage
5,0 (8 anmeldelser)
4,3
4,3
Brug Avatar.
Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, data processing. I can design and develop excel, ms access applications in quick time ensuring the final output is as per the precise requirement. Over 8 yrs I've worked in VBA technology and so I am accustomed to working with all sorts of excel, access related development. You can be sure that I will use my best skills to ensure the successful completion of the project. I highly value professionalism and hold myself strictly accountable to represent client's profile. I aim to form a long term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Vinay
$7 USD på 5 dage
4,8 (11 anmeldelser)
4,1
4,1
Brug Avatar.
I have the required expertise for developing your project. Check my reviews and portafolio. It is required your current macro as a base for developing changes.
$5 USD på 32 dage
4,8 (11 anmeldelser)
3,7
3,7
Brug Avatar.
Hi there! I am an expert in MS Excel with hands-on experience with VBA programming for macros. I look forward to receive more details of the project. Thank you. Warm regards, Naseef Ummer
$7 USD på 40 dage
5,0 (8 anmeldelser)
3,5
3,5
Brug Avatar.
Hello, I have more than 20 years working with Excel and 10 progrmming Excel Macros. Regards, José santos
$5 USD på 40 dage
5,0 (2 anmeldelser)
2,9
2,9
Brug Avatar.
Hi, I'm very interested in accomplishing this project as required, which I can do due to my experience and knowledge. Thank you for considering my bid. Kind regards.
$8 USD på 30 dage
4,5 (5 anmeldelser)
3,1
3,1
Brug Avatar.
Hello, I'm an expert in Excel an Visual Basic coding. count on me if you need my skills. Thanks, Tamar.
$8 USD på 3 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I had worked on complex Excel Macros and have designed & developed multiple macros for different reasons for small to large corporates like Reliance Industries, SAP etc. Please get in touch and I can start this work immediately.
$8 USD på 40 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Hi I expertise in VBA, Excel. I will be able to commit on the timelines once i will look at your file. Also I understand that you might not have much time, so i am flexible to work extra in order to meet the deadline. Thanks, Rohit
$7 USD på 5 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Hello, I am Adhy Wijaya. I am a new freelancer on freelancer.com, but I am member of Excel expert on another source. Could you please send your excel file to me, I will confirm if I can do this project before you give award. I think I can help you in this job because I have experience with big data in Microsoft Excel with VBA, Pivot Table, Pivot Charts, Power Pivot, conditional formatting and all functions as attached. . I hope you like my sample I made from the last jobs on my profile. My cost for this task is $8 but we can negotiate it and I guarantee with quality of my work. Please don't hesitate to contact me if you need to negotiate my cost. I am certain I am fit on this job because I have much experiences with Big Data in Microsoft Excel Macro Enable and All Functions. Let me know what ever you needing and I am waiting for your response on PMB. Best Regards Adhy Wijaya
$8 USD på 10 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I have written excel macros for close to 20 years, mainly for the financial industry. I should be able to complete your project in under the time allotted.
$10 USD på 5 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
A proposal has not yet been provided
$6 USD på 3 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
A proposal has not yet been provided
$5 USD på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
A proposal has not yet been provided
$5 USD på 3 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
A proposal has not yet been provided
$8 USD på 21 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Hi, we are a team of highly qualified developers. let us know if we can collaborate to take this engagement forward. Thanks, Vishwas
$3 USD på 8 dage
0,0 (0 anmeldelser)
2,3
2,3

Om klienten

Flag for UNITED STATES
Thornwood, United States
4,9
210
Betalingsmetode verificeret
Medlem siden jun. 10, 2013

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.