Hi guys, I am new here and I need some help regarding a splitting rows macro
Description:
1st part: To count how many entries are filled (by column A) not counting the 1st row
2nd part: divide the number above by 500
3rd part: after divided by 500, it will be rounded up (1501/500 will be 4)
4th part: create a new excel file per 500 (4 excel file will be created if there's 1501 rows), each excel file will only have 1 tab on the bottom left instead of the original 3 when you 1st create an excel file, and the tab name in each file would be 2-500, and 501-1000 for the 2nd created excel file (1st row being the topic that will display in all the created excel file)
5th part:generate the data into the newly created files (row 2 to 500 in 1st created file, row 501-1000 in 2nd file) (row 1 of each excel file created should be the row 1 of the original document)
6th part: save each excel file on to desktop and the name will be row 2-500.xls and so forth
Do you think this will be a long project or something a noob like me can't handle![]()
Bookmarks