Đã hoàn thành


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.

Kỹ năng: Delphi, Perl, Powershell, VB.NET, Visual Basic

Xem thêm: 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

Về Bên Thuê:
( 1 nhận xét ) Port Washington, United States

Mã Dự Án: #13110732

Đã trao cho:


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 Thêm

$17 USD trong 0 ngày
(1 Đánh Giá)

16 freelancer đang chào giá trung bình $34 cho công việc này

$60 USD trong 1 ngày
(117 Đánh Giá)

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 Thêm

$50 USD trong 1 ngày
(82 Đánh Giá)
$58 USD trong 2 ngày
(140 Đánh Giá)

ready to deliver asap

$30 USD trong 2 ngày
(66 Đánh Giá)

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 Thêm

$35 USD trong 1 ngày
(64 Đánh Giá)

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 trong 1 ngày
(49 Đánh Giá)

i can do it for you quickly and exactly

$30 USD trong 2 ngày
(42 Đánh Giá)

A proposal has not yet been provided

$17 USD trong 1 ngày
(16 Đánh Giá)

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 Thêm

$25 USD trong 0 ngày
(13 Đánh Giá)

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 Thêm

$27 USD trong 0 ngày
(2 Đánh Giá)

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 Thêm

$24 USD trong 6 ngày
(0 Đánh Giá)

A proposal has not yet been provided

$88 USD trong 30 ngày
(0 Đánh Giá)
$25 USD trong 1 ngày
(0 Đánh Giá)

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 trong 1 ngày
(0 Đánh Giá)

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 Thêm

$15 USD trong 1 ngày
(0 Đánh Giá)