VBA to include offset

[Ironman]

Hello everyone - - happy monday! right?!

I'm working on an Excel file that is a summary of updates on a list of projects that are currently being worked on. Columns A to L, see attached example file. In the attached there are two sheets, the FullSummary is the main sheet and the other, Example, is what I'm looking to accomplish via VBA and offsest.

For the first project in the list on FullSummary, A2 - L2 contain the basic info. What happens is we insert a row and put a comment in Cell C3. The next day if the project is still open we insert another row and put the latest comment/update in C4, again the next day in C5 and so on until the project is complete.

What I'm hoping to do is use offset to find the last update from column C and place it along side the value in A2, L2, C7 (see the Example sheet for what I'm looking to do).

Then the next row of my Example sheet would be: A8, L8, C11...and so on.

Would someone be able to assist with some code that would perform this? I'm thinking that offset with finding the last empty cell..etc. Any thoughts/suggestions? Thanks and enjoy your day!

[JBeaucaire]

As you add rows on the fullsummary, just be sure to include the Ticket# on each new row, then this stays pretty simple. Formulas added to Example.

[Ironman]

Thanks Jbearucaire - - that'll work, I don't like the look of the number going down the column (a), but I change the font to white and it seems to work fine. Thanks for the suggestion.