PC Review


Reply
Thread Tools Rate Thread

Change Cell Value and Subtract the cell value in another sheet

 
 
hon123456
Guest
Posts: n/a
 
      12th Jan 2008
Dear All,

I have two worksheet with the following data,


Sheet 1


Invoice Number Qty
Invoice-001 6


Sheet 2


Invoice Number Qty
Invoice-001 1

Now what I want is if the user Change the Qty of Invoice-001
in Sheet2, e.g. Change from
1 to 3. Because the difference from 1 to 3 is 2. Then I need to
subtract 2 from Qty of Invoice-001
Of Sheet1. If the user change the Qty of Invoice-001 of Sheet2 from 1
to 0, Then I will add 1 to
Qty of Invoice-001 in Sheet1. How can I do that?

Thanks


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
using the offset function to subtract a cell in b column from cell in a instead of adding mike Microsoft Excel Worksheet Functions 1 18th Oct 2004 08:44 AM
I need to subtract cell B-6 sheet2 from cell B12 sheet1/ Excel 2003 =?Utf-8?B?UVdFUlRZ?= Microsoft Excel New Users 2 5th Jun 2004 01:54 PM
Re: I need to subtract cell B-6 sheet2 from cell B12 sheet1/ Excel 2003 Dave R. Microsoft Excel Worksheet Functions 2 4th Jun 2004 11:34 PM
I need to subtract sheet 2 cell B6 minus sheet 1 B12, whats the formula thanks in advance =?Utf-8?B?cXdlcnR5?= Microsoft Excel New Users 3 3rd Jun 2004 11:18 PM
I need to subtract sheet 2 cell B6 minus sheet 1 B12, whats the formula =?Utf-8?B?RGFycmVu?= Microsoft Excel Worksheet Functions 3 3rd Jun 2004 10:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:17 AM.