Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any idea?
I'm not really sure how to explain this but I’m creating something fo work that will help us keep a record of computers that need to b worked on. I already have the calculations for the number of days it' been in the store. However, I want to now how to set it up so it wil auto fill a lot of columns to make it easier for me. I want to be abl to insert the clients name and then it will automatically insert th date I checked it in, and keep it there so i can do calculations late for the numbers of days we have had it in -- nemp ----------------------------------------------------------------------- nempo's Profile: http://www.excelforum.com/member.php...fo&userid=2840 View this thread: http://www.excelforum.com/showthread.php?threadid=47998 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any idea?
It sounds like you want to timestamp the entry of the Clients name. See
the following link on the subject: http://www.mcgimpsey.com/excel/timestamp.html Hope this helps Rowan nempo wrote: I'm not really sure how to explain this but I’m creating something for work that will help us keep a record of computers that need to be worked on. I already have the calculations for the number of days it's been in the store. However, I want to now how to set it up so it will auto fill a lot of columns to make it easier for me. I want to be able to insert the clients name and then it will automatically insert the date I checked it in, and keep it there so i can do calculations later for the numbers of days we have had it in. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any idea?
I can't seem to get it to work. I went to that site and i insert th code =IF(A1="","",IF(B1="",NOW(),B1)) I inserted it into C1, but when I have "cat" in B1 it won't displa anything until I put something into A1. Then it will paste whatever i in B1 to C1. I want it to look at A1 and if something is inserted int it B1 will output the m/d/year and keep that date there. I know th site you gave me is probably correct, but I can't get it to work Please help thank -- nemp ----------------------------------------------------------------------- nempo's Profile: http://www.excelforum.com/member.php...fo&userid=2840 View this thread: http://www.excelforum.com/showthread.php?threadid=47998 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any idea?
It is actually a circular reference so you need to place the formula in
B1. First set iteration ToolsOptionsCalculation check the iteration box. Then insert the formula in B1. Also if you just want the date and not the time then I would change the formula slightly to: =IF(A1="","",IF(B1="",TODAY(),B1)) Hope this helps Rowan nempo wrote: I can't seem to get it to work. I went to that site and i insert the code =IF(A1="","",IF(B1="",NOW(),B1)) I inserted it into C1, but when I have "cat" in B1 it won't display anything until I put something into A1. Then it will paste whatever is in B1 to C1. I want it to look at A1 and if something is inserted into it B1 will output the m/d/year and keep that date there. I know the site you gave me is probably correct, but I can't get it to work. Please help thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help!! No idea where to go next... | Excel Discussion (Misc queries) | |||
I've no idea how to do this. :( | Excel Worksheet Functions | |||
know possible, but have no idea how | Excel Programming | |||
any idea? | Links and Linking in Excel | |||
Help Please. No Idea what to look for or how to do this | Excel Discussion (Misc queries) |