Forum Discussion
Using one cell to append another
Hello, I use excel to track projects for my employer. The tracker contains multiple identifiers as well as cells for various status updates. A really simple version of my tracker would be: Row ...
With your permission, I recommend that you include a file (with no confidential data) and explain your plan on it.
This way you can be helped much faster.
Please ask yourself why someone who wants to help has to prepare the file as well?
* Knowing the Excel version and operating system would also be an advantage.
Thank you for your understanding and patience.
Nikolino
This way you can be helped much faster.
Please ask yourself why someone who wants to help has to prepare the file as well?
* Knowing the Excel version and operating system would also be an advantage.
Thank you for your understanding and patience.
Nikolino
Hi Nikolino,
Yes, that makes sense. I have attached a file that should work as placeholder for what my tracker really looks like.
So in column B, I'd like to just enter in the latest update for each project, hit enter and have that text automatically added to the same row in column C. For example: On 3/20/21 I have an update for project A1234567, I'd type that into cell B2, and while the previous text in that cell would go away, the 3/16/21 update would stay in cell C2, as well as the new text from B2 would be added there.
I have my doubts if this can be done, but I thought I'd check here.
Thank you!
Thomas