Hi albertd,
Welcome to Excel Fox…

I can help with some basic Excel VBA, but I no nothing about your project so I find it difficult to understand what you want.

It might be obvious to me later , as it is to you now, what you are asking.
But I need explanations set at a level for someone that has no idea at all about your project, and is starting from scratch.

All I can glean from your explanation is that you have a large data sheet, “Datadump”. Some how information from that needs to be put somewhere else. That is as much as I understand so far.


One of the images in your post looks like your worksheet “Template”
The other image, “Final.jpg” , has come out very small, so I can’t really see anything from it.


It might be helpful to upload a couple of files, or alternatively , a single file with a few worksheets.
Try to show the situation “Before” and “After” with a small sample set of data. Use just enough data to demonstrate what you want to do. (Desensitize the data if necessary: remove real names or make up data, but keep the format looking as realistic as possible)

“Before” is what you start with before any coding is run.

The “After” is based on the “Before” and is hand filled by you. You do in the “After” what you want the coding to do . And explain exactly what you did and why.

Then I or someone may be able to help develop coding to do what you did. Your original explanation might then help further, but initially you need to walk someone through exactly what you want to do with a small amount of sample data.



Alan