Need VBA to create table from sheet data with dropdown list option

[crusadessword]

Dear expert

i have set of rawdata which need to create dashboard, i have huge data which takes alot time

i want vba code to create dashboard table A to Z team wise order,

code has to start from A9 cell
A9 Merge 3 cell down = Team
B9 Merge 3 cell down = Function
C10 = Associate Name

and dropdown list of Client status and Status fill against row 8:8 till end of date

follow as above till end of text

find the attachment.

when ever click button delete table upgrade newly

thanks

[Sintek]

Rule No 1 in Excel...Don't merge cells...

[Effinovate]

I wouldn't recommend using merged cells, they can be a real pain to work with. But if you must, you can merge cells like this:

Please Login or Register  to view this content.

I would put the data in "Rawdata" into an array, loop through while adding the new rows in the project sheet.

If you give it a go and send through your code, we can help if you get stuck

[crusadessword]

any help from expertise?