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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit the row specified by key column(ID)
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit the row specified by key column(ID)
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 | +-------------------------------------------------------------------+ -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=520882 |
Reply |
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) |