Hi everyone,
I don't think this is possible but thought I would ask here just in case. Here's my problem:
I'm building a repair management system in excel right now where every row represents one repair or one clients repair. One thing we need to constantly update is when and how many times that client is contacted upon completion of the repair. My issue is that right now record each and every time that client is contacted I have separate cells for each time. For example, A1 = March 2, A2 = March 4, A3 = March 10, etc. Is there a way maybe through concatenate function or any other function where I can condense all this info into one cell automatically after I update the cell. For example, if A1 = March 2, then A2 = March 2. as well. If I contact the client again on March 4, then the A1 = March 4, and the A2 now = March2, March 4.
Is this possible? Is there another way to manage this in a more space efficient way?
Please don't hesitate to ask any questions.
Thanks! - Julian
I don't think this is possible but thought I would ask here just in case. Here's my problem:
I'm building a repair management system in excel right now where every row represents one repair or one clients repair. One thing we need to constantly update is when and how many times that client is contacted upon completion of the repair. My issue is that right now record each and every time that client is contacted I have separate cells for each time. For example, A1 = March 2, A2 = March 4, A3 = March 10, etc. Is there a way maybe through concatenate function or any other function where I can condense all this info into one cell automatically after I update the cell. For example, if A1 = March 2, then A2 = March 2. as well. If I contact the client again on March 4, then the A1 = March 4, and the A2 now = March2, March 4.
Is this possible? Is there another way to manage this in a more space efficient way?
Please don't hesitate to ask any questions.
Thanks! - Julian