Hi All,
Nice to see this forum postings. I need to create a work book with VBA code which will create and append data from Sheet 1 to Sheet 2 in a specified format.
Sheet 1 contains data rows from A2 onwards. For each unique value in column A, i need to copy A to K from Sheet 1 to Sheet 2 at specified destination as header and then append data of Sheet 1 from L to U into a different location in Sheet 2. Note that Header and Sub header in Sheet 2 are fixed between Header from A1 to N1 and sub header from E4 to N4. Same structure will get added when a new unique value in Column A is found in Sheet 1.
Sample format is attached.
I am able to reach to this stage of preparing Sheet 1 using EXCEL Pivot, Filteration, copy from other sheets using VBA code. But now stuck for this specialized formatting. Can any one suggest suitable VBA code?
Thanks a lot for every one for understanding on above.
Best Regards,
Narasimharao
Bookmarks