Automated Data Population

Hi All

I have tried ALL options - vlookups, macros (VBS), buttons, etc. I am not expert in excel but know my way around. Hopefully there is some guru's out here to assist as my last resort. Thank you in anticipation

So I have attached the sample sheet - RAW report data is on sheet as per sample. Ideally, a few things needs to happen:

1. A sheet needs to be created in the same workbook (named based on each unique name as per column J)
2. The same headers needs to be copied to each of the created sheets (along with the row if that name of the sheet matches the name in that row (sheet))

As mentioned, I managed to scrape together a few macro's, each doing a little bit of the task,, but it creates sheets for blank cells, then I had to create another VBS to delete those, before running the next to cope the headers, and the next to copy data.... etc. It gets messy.

I truly appreciate ANY guidance or help on this - i give up!

Oh - and 3. Column O and P needs to be formatted as number.

Hi There

Thank you so much for your response! I would prefer to me number (with no decimals) for the time being

At the moment, as is, it creates a sheets called Name1, but not the rest, and also makes the fields on RAW-Data filterable, which is exactly what is needed, only that it needs to make a sheet for each "Name" and leave the RAW data sheet as is.

Hope this makes sense and thanks again- i truly appreciate your input!

You are the Master! Thank you ever sooo much!!!