Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit the row specified by key column(ID)
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Erorr when 'edit query' | Excel Discussion (Misc queries) | |||
get edit mode on data lines in chart wizard | Charts and Charting in Excel | |||
EDIT FORMULA BAR in excel 2003? why not? where is it? | Excel Worksheet Functions | |||
Scan and edit document in excel 2003. | Excel Discussion (Misc queries) | |||
How to switch to edit the cell | Excel Discussion (Misc queries) |