Käynnissä

vbscript

I have an inventory excel file. In cell F2, I have a button that I would like to perform the following action when clicked: For the fields labeled QUANTITY and ORDER, subtract ORDER[cell] from QUANTITY[cell] and return result in QUANTITY[cell]. After which, script should clear/reset all values from ORDER field. This is essentially taking a customer's quantity requests, subtracting it from the total inventory on hand so that the new quantity totals are properly reflected when the order is executed. There should be a command prompt informing the user "Are you sure you want to execute the pick list?", and the QUANTITY fields should be locked and only editable by executing the script.

Updated Warehouse file attached. We had to edit a little bit of the layout and design of the template. No structural changes.

Taidot: Delphi, Perl, Powershell, VB.NET, Visual Basic

Näytä lisää: vbscript copy file excel, vbscript export excel sheet text file, vbscript check excel file, vbscript search excel write text file, vbscript read excel file, vbscript open xml file excel, vbscript xml file read functions, vbscript import text file excel, vbscript file import handling excel, import text file excel file vbscript, read local excel file using html vbscript, sample read file excel vbscript, vbscript update excel odbc connection, download excel using vbscript, name sheets excel using vbscript, vbscript text file, vbscript sql, vbscript html create email subscribe page, asp vbscript write sql example, search excel file vbscript, vbscript xml, vbscript list files, vbscript processing text file, vbscript merge files, vbscript sqlserver

Tietoa työnantajasta:
( 1 arvostelu ) Port Washington, United States

Projektin tunnus: #13110732

Myönnetty käyttäjälle:

Davzone

Hi, I've read your request and finished without being selected, I've alreadi did your requirements, lock the quantity column and the order column substracts from quantity I have a question , If the order is bigger t Lisää

17 $ USD 0 päivässä
(1 arvostelu)
0.5

16 freelanceria on tarjonnut keskimäärin 34 $ tähän työhön

60 $ USD 1 päivässä
(117 arvostelua)
7.1
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Lisää

50 $ USD 1 päivässä
(82 arvostelua)
6.7
58 $ USD 2 päivässä
(140 arvostelua)
6.7
srinichal

ready to deliver asap

30 $ USD 2 päivässä
(66 arvostelua)
6.3
koolsidz

Hello :) My Credentials: 20+ of Excel/VBA Experience. [url removed, login to view] I am an MS-Excel Expert besides being an MVP (Microsoft Valuable Professional). If you see my reviews by navigatin Lisää

35 $ USD 1 päivässä
(64 arvostelua)
5.9
avdushima

I am an experienced programmer, with more than 10 years of experience. I understand exactly what you need. I promise you will be satisfied with my work. Thank you for your trust.

30 $ USD 1 päivässä
(49 arvostelua)
5.9
zebracaro

i can do it for you quickly and exactly

30 $ USD 2 päivässä
(42 arvostelua)
5.0
The24CarrotsInc

A proposal has not yet been provided

17 $ USD 1 päivässä
(16 arvostelua)
4.1
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details Lisää

25 $ USD 0 päivässä
(13 arvostelua)
4.0
fb57e1f6608abfb

Hi, I have ~4+ years of experience of creating and operating low to very high complexity of Excel/VBA/SQL,SAS, Powerpoint based tools/processes, reports. I can assure you of high quality and on-time deliverable Lisää

27 $ USD 0 päivässä
(2 arvostelua)
3.1
rapidsoft4

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have c Lisää

24 $ USD 6 päivässä
(0 arvostelua)
0.0
SantiagoBernabe

A proposal has not yet been provided

88 $ USD 30 päivässä
(0 arvostelua)
0.0
25 $ USD 1 päivässä
(0 arvostelua)
0.0
mgo57ed54cbe3327

Hello, can do the script you want wich excel, what is the version of microsoft office do you have ? if interested, please contact me.

15 $ USD 1 päivässä
(0 arvostelua)
0.0
gpatitucci

Hi. I saw your project and I'm interested in giving you a solution. For many years I have been working in Excel developing functions with VBA macros and what you are asking for, I can solve quickly. Contact me i Lisää

15 $ USD 1 päivässä
(0 arvostelua)
0.0