Hi all,
i am currently working on a project where i have a large list of exactly 6030 unique names under the title "Module Name" located under Column A.
I have categorized each row with a name under Column B - total of 51 categories.
i would like to run a macro that would create New sheets based on these 51 categories as well as move or copy the rows to the appropriate sheet.
i am a beginner in terms of macros and i did try to research on the forums for a macro similar to this. i found one where based on the input of a cell value, the row moves the sheet, but the problem is, i have already input this cell value, and to input 6020 rows individually will take a large time.
Any solution is greatly appreciated.
i am currently working on a project where i have a large list of exactly 6030 unique names under the title "Module Name" located under Column A.
I have categorized each row with a name under Column B - total of 51 categories.
i would like to run a macro that would create New sheets based on these 51 categories as well as move or copy the rows to the appropriate sheet.
i am a beginner in terms of macros and i did try to research on the forums for a macro similar to this. i found one where based on the input of a cell value, the row moves the sheet, but the problem is, i have already input this cell value, and to input 6020 rows individually will take a large time.
Any solution is greatly appreciated.