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.

[paul]

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..
--
paul
remove nospam for email addy!



"marcoR2D2" wrote:

>
> 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 |
> +-------------------------------------------------------------------+
>
> --
> marcoR2D2
> ------------------------------------------------------------------------
> marcoR2D2's Profile: http://www.excelforum.com/member.php...o&userid=32327
> View this thread: http://www.excelforum.com/showthread...hreadid=520882
>
>

[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.