Lukket

Building a simple Excel Inventory Database using VBA 2

I am building a simple Excel Inventory Database to capture Laptops and Desktops coming in and out of Store Room.

We be using a Barcode scanner to scan the Serial Number on the Machine onto an Excel Form and input additional details on the form. Before this record is saved inside the Inventory Databse(Excel Worksheet).

This Form will serve 2 purpose, Machines coming into the Store, and Machines moving out of the store. The same Serial Number will be scanned using the Scanner on the Form.

So i basically need a VBA Forms for Moving In and Moving Out(with additional data to be inputted). The VBA form will dynamically query my Inventory Table and Insert and Update data accordingly.

I would need an Audit Log of all Entries that are recorded

I am currently on a tight schedule and not able to program this VBA myself hence need someone to program this for me.

Additional requirement : I will like to have a feature whereby I am able to email an Acknowledgement Email to the Person that I receive the Machine or Issue out the Machine too.

I have created the Sample form designs with the necessary fields.

I would need delivery of this project in 1 Day.

Evner: Excel, Excel VBA

Se mere: create simple java inventory program using arrays, build simple php inventory database, migration excel file database using cnet, build inventory database using mysql, restart access database using vba, send data excel iseries as400 using vba, excel resizing images using vba, import data database via odbc excel using vba, need simple invoice inventory database, simple online inventory database, creating simple shopping cart database using, import excel data database using, insert data excel file database using jsp, simple excel project database, simple mysql inventory database example php, import excel file database using php, inserting data excel file database using jsp, jsp program insert data excel file database using

Om arbejdsgiveren:
( 0 bedømmelser ) Choa Chu Kang New Town, Singapore

Projekt ID: #23919389

17 freelancere byder i gennemsnit $45 på dette job

schoudhary1553

Hello, I can help you with your project - Building a simple Excel Inventory Database using VBA 2 I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I Flere

$140 SGD in 5 dage
(328 bedømmelser)
8.0
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Flere

$56 SGD på 1 dag
(151 bedømmelser)
6.2
ravinderkumar248

Hi Good Day, I can do this immediate after you accept my bid I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and [login to view URL] give me this o Flere

$95 SGD in 3 dage
(22 bedømmelser)
4.6
khanjzthanjzt

Hi I have read and understand the requirement, it’s very much doable and I’m experienced in making Macros, using VBA and mapping in excel. Allow me to complete this work without any error. Warmest Regards https://www.f Flere

$100 SGD in 3 dage
(10 bedømmelser)
4.5
Ladiginvladislav

Hi sir. ⭐ Macro and vba Expert is here!! ⭐ I now am checking your requirements,So I can do it perfectly in 1 days as you want. I have excellent knowledge and experience of creating User Form, Command Button, Drop D Flere

$21 SGD in 7 dage
(5 bedømmelser)
3.6
Crayon1365

Hello i'm developer with rich experience in ms excel and vba macro please see my portfolios in excel, already i have done the same project best regards

$30 SGD in 2 dage
(4 bedømmelser)
1.2
techwizwwm

I have a good knowledge of VBA and excel and have build many models which saves time and cost for the company

$36 SGD in 2 dage
(0 bedømmelser)
0.0
efedriko1234

Hello from Australia. Honest and reliable company committed in delivering complex or simple projects on-time. Low prices and highly skilled developers with great communication skills. Wide range of technologies and sy Flere

$30 SGD in 7 dage
(0 bedømmelser)
0.0
Cowen2019

I have looked at the project very closely and found it to be something that I am comfortable with. Please activate a chat so we can discuss further.

$12 SGD in 7 dage
(0 bedømmelser)
0.0
mahetab89

Hi there! I have read and understood all the requirements of your project. I am highly skilled in MS Excel,Adv Excel,VBA,Excel Macros,Dashboard,MS SQL,Data Mining,Analysis,Designing,Coding,Testing,Reporting,MS Access D Flere

$30 SGD in 3 dage
(0 bedømmelser)
0.0
elajmi

I can do this application whatever you want with a nice interface and the database will be updated every new coming and every out of computer or what you are solding

$21 SGD in 10 dage
(0 bedømmelser)
0.0
pavitralachu

I will able to this work because and complete it with in ur expecting time ..i think its much easier to me to do this

$46 SGD in 3 dage
(0 bedømmelser)
0.0
$30 SGD på 1 dag
(0 bedømmelser)
0.0
Avijits77

I can do the work as you need Relevant Skills and Experience Data entry, excel, word,

$27 SGD in 7 dage
(0 bedømmelser)
0.0
snkumari

Hi I'm interested in this opportunity. I have good experience in it. I xam deliver you the work in less time and with minimum amount charged. Thanks Sneha

$18 SGD in 10 dage
(0 bedømmelser)
0.0
SupremeWriters

I will help you SIMPLE EXCEL. I am working with a team of data entrant experts who can complete your projects within your given deadline. We can manage bulk data entry work in a very short period of time. Our service Flere

$12 SGD på 1 dag
(0 bedømmelser)
0.0
Bhopalmacro

I had gone through the requirements. find interesting to do such work. Looking forward to here from you.

$61 SGD in 7 dage
(0 bedømmelser)
0.0