Vba code to copy unique email id data from input sheet to output sheet

Hi excel guru,

Need your help!

From input sheet from column D i want unique id in output sheet in column D and also in reference to these unique id i want Name,City,Mobile number from input sheet to output sheet in column E i want count of email and in column F Minimum budget and in Column G Maximum budget and in H column bedroom and in I column Locality
i require all unique locality in one cell and also i require all unique Project in one cell.

Please find the attached file for your reference.

Thanks

Hi All,

I have created this macro to automate this report but i stuck at column F to J.

Please help me to automate this report.

Thanks

Please Login or Register  to view this content.

Hi karedog,
Thank you for your reply - much appreciated.
That is exactly what I am looking for.
Thank you!