marianocaifanjaguar
New Member
hello. Can someone of you kind folks please provide some help with following?
I need a vba code in order to convert raw data into specific layout (w some replication of records)
Sample of raw data is shown in range A:Q
Desired output of vba code is shown in range S:Ai
The raw data could be up to 80,000 rows
Ideally one sheet would have the extensive raw data, and the VBA code should place the 'revised databank' into a different sheet
VBA code should unmerged specific cells, and replicate data (in a downward basis, & just for those records in which the merging implied "summarized presentation" )
I am very beginner about vba code so please kindly let me know where the code should be placed/saved and how to run it
I kindly appreciate anyones help as previous occasions. I hope you all are healthy and stable. Please advice at any oportunity possible.
Thanks really!
I need a vba code in order to convert raw data into specific layout (w some replication of records)
Sample of raw data is shown in range A:Q
Desired output of vba code is shown in range S:Ai
The raw data could be up to 80,000 rows
Ideally one sheet would have the extensive raw data, and the VBA code should place the 'revised databank' into a different sheet
VBA code should unmerged specific cells, and replicate data (in a downward basis, & just for those records in which the merging implied "summarized presentation" )
I am very beginner about vba code so please kindly let me know where the code should be placed/saved and how to run it
I kindly appreciate anyones help as previous occasions. I hope you all are healthy and stable. Please advice at any oportunity possible.
Thanks really!