Using one cell to append another

%3CLINGO-SUB%20id%3D%22lingo-sub-2214852%22%20slang%3D%22en-US%22%3EUsing%20one%20cell%20to%20append%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2214852%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3EI%20use%20excel%20to%20track%20projects%20for%20my%20employer.%20The%20tracker%20contains%20multiple%20identifiers%20as%20well%20as%20cells%20for%20various%20status%20updates.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20really%20simple%20version%20of%20my%20tracker%20would%20be%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3ERow%20A%3A%20Headers%3A%3C%2FSTRONG%3E%20A1%3A%20Project%20Number%2C%20B1%3A%20(Not%20used)%2C%20C1%3A%20Status%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ERight%20now%2C%20I%20keep%20adding%20to%20to%20cell%20C2%3A%3C%2FSTRONG%3E%203%2F16%2F21%3A%20Vendor%20states%20part%20will%20arrive%20on%203%2F20.%20-%203%2F10%2F21%3A%20Vendor%20ordered%20part.%20-%203%2F5%2F21%3A%20Vendor%20states%20we%20need%20a%20new%20part%20for%20this%20project.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I'd%20like%20to%20do%20is%20use%20cell%20B2%20for%20the%20latest%20update%2C%20but%20have%20it%20automatically%20appended%20to%20cell%20C2%2C%20without%20deleting%20any%20of%20what's%20already%20there.%20%3CSTRONG%3ESo%20if%20I%20on%203%2F20%20type%20into%20B2%3C%2FSTRONG%3E%3A%203%2F20%2F21%20Vendor%20states%20part%20will%20be%20late%20-%20%22%2C%20that%20text%20automatically%20gets%20appended%20to%20C2s%20existing%20text.%20And%20again%20on%203%2F30%2C%20when%20the%20part%20is%20still%20not%20here%2C%20I%20just%20enter%20that%20value%20into%20B2%2C%20while%20C2%20keeps%20a%20record%20of%20all%20updates.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20that%20made%20sense%2C%20and%20if%20it%20did%2C%20is%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3CBR%20%2F%3EThomas%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2214852%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 A: Headers: A1: Project Number, B1: (Not used), C1: Status

 

Right now, I keep adding to to cell C2: 3/16/21: Vendor states part will arrive on 3/20. - 3/10/21: Vendor ordered part. - 3/5/21: Vendor states we need a new part for this project.

 

What I'd like to do is use cell B2 for the latest update, but have it automatically appended to cell C2, without deleting any of what's already there. So if I on 3/20 type into B2: 3/20/21 Vendor states part will be late - ", that text automatically gets appended to C2s existing text. And again on 3/30, when the part is still not here, I just enter that value into B2, while C2 keeps a record of all updates.

 

I hope that made sense, and if it did, is this possible?

 

Edit: This would be on Desktop/Win10 Excel 365

 

Thanks!
Thomas

2 Replies
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

@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