PDA

View Full Version : Rearrange Data - Sheet 1 into Sheet 2 Macro?



BlakeReuben
03-16-2021, 02:11 AM
Pulling my hair out, hoping someone can help. I'm looking for a macro to turn data in sheet 1 into sheet 2. Thank you.

Thank you very much and apologies for the cross posting. Carim from the Ozgrid kindly took some time to create the attached. Also thank you to Alan for your input. Greatly appreciated!








Cross Posts

Rearranging Data, Sheet 1 into Sheet 2 ('https://www.ozgrid.com/forum/index.php?thread/1229255-rearranging-data-sheet-1-into-sheet-2/&postID=1246394#post1246394')
https://www.mrexcel.com/board/threads/how-to-rearrange-data-sheet-1-into-sheet-2.1165012/
https://www.excelforum.com/excel-programming-vba-macros/1344161-rearrange-data-sheet-1-into-sheet-2-macro.html/
http://www.excelforum.com/excel-programming-vba-macros/1344161-rearrange-data-sheet-1-into-sheet-2-macro.html

sandy666
03-16-2021, 03:39 AM
are you sure your expected result is correct?
because I got
3547

Could you explain your logic from source data to the result?