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


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.

Evner: Excel, Java

Se mere: java and excel, bookkeeping from, vb in excel, vb excel, java+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

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

Projekt ID: #6025951

Tildelt til:


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 Flere

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

18 freelancers are bidding on average $145 for this job


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 Flere

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

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 Flere

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

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)

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 Flere

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

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 http://www.freelancer.com/users/feedback_1193882.html?period=entire_histor Flere

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

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)

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 Flere

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

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 Flere

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

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 Flere

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

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)

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 Flere

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

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 Flere

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

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 Flere

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

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 Flere

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

A proposal has not yet been provided

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

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 Flere

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

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 ... Flere

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

A proposal has not yet been provided

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

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 Flere

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