Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell input on certian dates!!
Ok, heres my question. on sheet2 i have a list of items in col A that i inventory daily, in col B i enter those qtys. ex. A B Beef 3 On Sheet1 in col A i have the dates for the month A B 8/4/2005 8/5/2005 8/6/2005 i need sheet1 col b to lookup and input the number from sheet 2 col b on the spacific date that i am entering it but i need that number to stay there when i change the number the next day. i know its kind of vauge but i am new at excel and could really use the help!!! thank you!! -- n0 h4ck1ng ------------------------------------------------------------------------ n0 h4ck1ng's Profile: http://www.excelforum.com/member.php...o&userid=18410 View this thread: http://www.excelforum.com/showthread...hreadid=393159 |
#2
|
|||
|
|||
In sheet 1, you have only one B column. Do you want to display the summary of
inventory there? Please do make it clear. "n0 h4ck1ng" wrote: Ok, heres my question. on sheet2 i have a list of items in col A that i inventory daily, in col B i enter those qtys. ex. A B Beef 3 On Sheet1 in col A i have the dates for the month A B 8/4/2005 8/5/2005 8/6/2005 i need sheet1 col b to lookup and input the number from sheet 2 col b on the spacific date that i am entering it but i need that number to stay there when i change the number the next day. i know its kind of vauge but i am new at excel and could really use the help!!! thank you!! -- n0 h4ck1ng ------------------------------------------------------------------------ n0 h4ck1ng's Profile: http://www.excelforum.com/member.php...o&userid=18410 View this thread: http://www.excelforum.com/showthread...hreadid=393159 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Input cell on Data Table will not work | Excel Discussion (Misc queries) | |||
format cell from data input to output form | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
How do I match two cells and input a value in a different cell? | Excel Worksheet Functions |