Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 1st, 2011, 05:29 PM
Registered User
Join Date: Apr 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help with stock control sheet

Hi everyone
I am looking for a bit of help with a macro I am thinking of creating.
Basically I am working with 2 sheets.
Sheet4 is the master data sheet.
Sheet5 is the calculation results sheet.
This idea is I use Sheet5 to find out the stock that I need to make a product.
Then in the next column in Sheet5 I calculate the stock quantity left.
My problem is I need to deduct the quantity required from the stock quantity in sheet4.
To do this I assume the best way would be to put a button on sheet 5 and assign a macro to it so every time the button is clicked the macro does the rest.
I need to alter the stock value for the corresponding item in sheet4.
So say for the screw in sheet5 the stock value which is obtained via the VLOOKUP (in cell D3) needs to be reduced by the qty 8 (in cell A3).
So at the end of the day when I click in the button the stock value for the screw in sheet4 decreases by 8 it that makes any sense to you.
Basically I should end up with the red values in sheet4 when I click the button once.
I am OK with excel functions but am just beginning with macros.
Sorry if I haven't made myself clear.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Workbook,Copy Sheet,Move Sheet, Close/Save ptrussell2009 Excel VBA 0 June 13th, 2008 02:28 PM
access function in data sheet(another sheet) jani Excel VBA 1 May 21st, 2008 07:15 PM
Stock feed hudeanee Excel VBA 1 July 24th, 2007 08:29 PM
stock management- closing stock and opening stock bright_mulenga Access 1 July 16th, 2007 07:11 AM
Stock Quote JonnyRPI Classic ASP Basics 1 June 3rd, 2003 09:43 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.