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:


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)

16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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

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)
$58 USD 2 päivässä
(140 arvostelua)

ready to deliver asap

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

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)

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)

i can do it for you quickly and exactly

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

A proposal has not yet been provided

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

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)

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)

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)

A proposal has not yet been provided

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

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)

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)