Build a few macros to develop a stocktake sheet


I need someone proficient in VBA who can build me a few Macros for an inventory stocktake sheet. I already have an activex combo box which generates a new entry every time I select a name from a drop down list. Now I need three things.

1. I need a button so that once the user inputs data (stock out, stock in etc), a confirmation pops up asking them if it's correct. Once the user click on it, the sheet will save (in two locations if possible) then the input cells for that entry become locked and aren't able to be modified anymore (unless I unprotect the sheet).

2. Once a name is selected from the drop down box, a time stamp (date and time in separate cells) is generated. I've tried using something similar to: If(cell <>"",NOW(),""). However, everytime a name is selected from the list, all of the old entries update to the current time. I need it to capture the time once the name is selected and that's it.

3. Once the time stamp has been generated, I want an if statement to read the time and see if it falls between 06:00 and 17:59, display "DS" or if it's between 18:00 and 05:59, display "NS" in a separate cell

I will provide a template and the sheet passwords. Please provide a price and expected completion time.

Kemahiran: Excel, Kejuruteraan Perisian, VB.NET, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: how to maintain store inventory in excel, how to create inventory management system in excel, stocktake template, free excel inventory template with formulas, excel formulas for inventory control, inventory spreadsheet template - excel product tracking, inventory and sales manager (excel template), running inventory excel template, build content management system newspaper website using dreamwaever, develop time attendance sysm using vbnet, develop currecy converter project using net, develop email blasting service using php, build real estate websites google maps using php, develop inventory management application using visual basic, excel sheet cration using aspnet, develop store management system using, develop point sales system using visual studio 2005, develop hospital management system using, develop gmail chat aspnet using, develop mysql database excelsheet using php

Tentang Majikan:
( 3 ulasan ) MAYLANDS, Australia

ID Projek: #17668578

Dianugerahkan kepada:


Hi, Nice to know your need. I am an excel, excel vba expert and have delivered around fifty solutions excel in the past eight months. Willing to work with you. Thank you, Regards.

$155 AUD dalam 2 hari
(78 Ulasan)

6 pekerja bebas membida secara purata $153 untuk pekerjaan ini


"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m Lagi

$200 AUD dalam 3 hari
(183 Ulasan)

- For the Inventory Stock take sheet - Getting data for Stock in and Stock out - Confirmation to protect the data - Timestamp for the name selected and displaying DS or NS - Can be completed in 2 days for this f Lagi

$100 AUD dalam 3 hari
(50 Ulasan)

Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can write this VBA programme. That will perform above given tasks. Please come on chat for more details. Awaiting your response. Lagi

$50 AUD dalam 2 hari
(41 Ulasan)
$277 AUD dalam 5 hari
(7 Ulasan)

Good Day, I am Marceli, I am recently working with macros and different VBA related codes and excel formulas. Your project is a catch to my attention and would be glad to have me try this out. I want to be honest and Lagi

$138 AUD dalam 7 hari
(0 Ulasan)