Edit the row specified by key column(ID)

[marcoR2D2]

Hi,

I'm excel beginner,and I'm facing a problem I cannot solve.
I want to enter some values(IDs,numbers) in rows of one sheet,and
(immediately or on button click) the corresponding row(by ID) in the
other sheet to be modified.How can i do that?

_More_detailed_explanation_
I attached a very small .xls example of what I'm trying to do:
- I have two worksheets,one is a simple product list,other a simple
order list
- Problem: in the order sheet i select *product ID* (from a list),and
number of products i order; in products sheet total number of that
product should be reduced for the number of products that are ordered.
(for example,if i had 100 shirts in products sheet,when 10 shirts are
ordered in order sheet,90 should be left in products sheet).

One more thing,in the order sheet i can order hats first,then
shirts,then sneakers,so random order-i dont know what is ordered in
which row.

I guess I need some macro to do that...

So if someone can help me?

Thanx in advance.


+-------------------------------------------------------------------+
|Filename: Simple2sheets.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4433 |
+-------------------------------------------------------------------+

 

[Guest]

i think the order sheet can easily be acheived using the vlookup function,but
I am a little confused with your arithmetic.....if you order 10 shirts when
you have 100 shirts wont you end up with 110 shirts?The rewriting of your
product sheet would have to be done by macro or manually,once the ordered
product arrived??Or are you despatching the shirts......whatever the new
quantity is either manual or macro..

 

[Gary Brown]

Try the attached spreadsheet. I have added a bonus column to give you a
warning if you have over ordered a type of goods.


+-------------------------------------------------------------------+
|Filename: Simple2sheets.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4436 |
+-------------------------------------------------------------------+