I gang

Complete the functionalities of an Excel file with VB script for inventory bookkeeping.

We are looking for someone to complete the functionalities of an Excel file with VB script for inventory bookkeeping.

In the Excel file there are 3 tabs:

#1. Input tab: VINinput & Record

#2. Lookup table table:Data for Lookup

#3. Output tab: Final Result in Excel

Functionalities

a. Generate content of Tab#3 based on inputs from Tab#1 and Tab#2. Tab#3 should instantly reflect changes made in Tab#1 and Tab#2.

b. In Tab#3, by clicking a "Generate NotePad File" button, a txt file needs to be generated in the format provided. There are 3 sample files provided in the attachment.

Færdigheder: Excel, Java

Se mere: bookkeeping from, vb excel, java excel, excel java, excel inventory, excel 7, bookkeeping, inventory excel format, excel data table lookup, table excel java, java table excel, inventory files, data file notepad, excel inputs, excel inventory record, generate java files, java output file, data output excel java, record lookup, data sample notepad, input inventory data, generated java file, notepad data file, notepad java, excel inventory input

Om arbejdsgiveren:
( 10 bedømmelser ) Norcross, United States

Projekt-ID: #6025951

Tildelt til:

jaylancer43

Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n Mere

$150 USD in 5 dage
(57 bedømmelser)
5.4

18 freelancere byder i gennemsnit $145 for dette job

trustus

Hello , We have a team of Skilled Java-J2EE professionals with experience up to 8 yrs. Our Expertise is J2EE: 1) Frameworks: Struts, Spring , Hibernate , Lucerne, Quartz, Ant, , Cruise Control, jUnit, Db Mere

$144 USD in 7 dage
(16 bedømmelser)
6.5
seaanddream

Hi, your 5-star excel & vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many similar excel/vba tasks, all achieved with Mere

$150 USD in 5 dage
(71 bedømmelser)
6.2
zExcel

Hi, I'll be happy to help you with this project Please feel free to message me if you need to discuss any questions you might have prior to award

$194 USD in 2 dage
(84 bedømmelser)
6.2
maverick44000

Hi there. I have done a very similar project in Excel before and I can make this one work just as you desire. Would you like to bar scan the parts numbers into sheet ? Kindly discuss prior to offering the project. Reg Mere

$300 USD in 3 dage
(40 bedømmelser)
6.1
koolsidz

Hello :) I have a sample file ready for a similar project. I am an VB / Excel Expert. If you see my reviews by navigating to this link [url removed, login to view] Mere

$166 USD in 2 dage
(107 bedømmelser)
5.9
pkcyber

see my existing application, it might help in your work, i can modify it as per your requirements. [url removed, login to view]

$100 USD in 2 dage
(30 bedømmelser)
5.6
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Mere

$157 USD in 2 dage
(45 bedømmelser)
5.3
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Mere

$150 USD in 7 dage
(36 bedømmelser)
5.2
satsin7

Hi! I have seen you files and this project can be done in combination of Excel formula and Visual Basic. Is there a maximum number/outer limit of parts matching a part number? Please see my profile for recommendati Mere

$100 USD in 5 dage
(22 bedømmelser)
5.1
SoftwareEng8876

Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [url removed, login to view] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..

$250 USD in 3 dage
(24 bedømmelser)
4.7
ethicalboy

Hello ready to start asap to deliver you, I hope you do not want reading barcodes here in macro and you expect us to work on macro after you get the scanned file, I can deliver it to you fast, also about me: I am m.s Mere

$105 USD in 3 dage
(38 bedømmelser)
4.8
paris2785

Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstrat Mere

$59 USD in 3 dage
(20 bedømmelser)
4.0
Baxter2008

Hello My name is Brent and I am an Excel VBA developer. I've read your requirements and I can quickly and easily set up the macros you need to create a automatic update of the output tab using events that fire w Mere

$60 USD in 3 dage
(18 bedømmelser)
3.9
williammatheson

Hello, I am an Engineer from Nova Scotia, Canada. I work for a large Engineering/Project Management company. I am relatively new to Freelancer, but I've programmed countless VBA projects for my employer; budgeting Mere

$177 USD in 3 dage
(5 bedømmelser)
3.8
topacademics

A proposal has not yet been provided

$200 USD in 3 dage
(2 bedømmelser)
3.8
JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have many years of experience working with macros and writing code / debugging Excel VBA code. You may che Mere

$105 USD in 2 dage
(6 bedømmelser)
3.1
beej0y

HI, after checking the initial requires, i am here for your kind concern that some people bid with $144 or $5550 which is default in system and totally a fake estimate. They increase amount after you knock them lol ... Mere

$150 USD in 5 dage
(3 bedømmelser)
2.6
catstevens2009

A proposal has not yet been provided

$150 USD in 2 dage
(4 bedømmelser)
2.0
arunpr26

Hi Greetings!! I have 5+ years’ of experience in data analysis, data modeling and data entry in Excel. Placed a few documents in my portfolio, please have a look on those to get an idea on my skill sets and the Mere

$150 USD in 3 dage
(1 bedømmelse)
1.9