Need Macro code to split data split in 7 sheets based on variable rows in column A
Hello, i am facing problem in splitting data equally in 7 sheets, the data i split is based upon column A and each day the data in column A varies from 30000 to 80000 (eg today count is 30000 next day may be 80000 in column A). need urgent help from an expert.
Thanx
What do you have as a starting point?
Do you have a workbook containing 1 sheet of data (30000 to 80000 rows) and then 7 blank sheets that you need separating?
How do you decide what sheet the data goes on? Im assuming its on a row by row basis ie row 1 of the data may go on sheet 4 while row 2 goes on sheet 1 etc?
If someone has helped you then please add to their Reputation
Here starting point is A2 (2nd row), Row 1 consist headers from A1:AJ1. The problem is this file has data in sheet1 from Col A till Col AJ. I need to split all data in 7 sheets in a same file also there is no limit of rows, daily i have to count filled data in column A and divide it equally to 7 sheets, My requirement is to split data only on the bases filled rows of column A that i can split rows equally whatever the rows count, also if possible copy header (A1:AJ1) in all sheets and sheet name should also be changed to AA,BB,CC,DD,EE,FF,GG.
sorry just to be sure Im reading this correctly, you say that the data is split based on column A but then say that you want to split data equally.
Are you saying therefore that if you had say (for ease of calcs) 70,000 rows then you want 10,000 rows in each of the 7 sheets. If so, is this the 1st 10,000 in sheet 1, the next 10k in 2 etc etc?
In a column A there are thousands Product IDs, (Numeric values), Yes i want for example 70,000 rows equally divided in to 7 sheets (10,000 rows in each sheet), for example sheet2 contain data from A2:AJ10000 and then Sheet2 contain Data from A10001:AJ20001 and so on.
Its been rushed so could definitely be written better, but it works
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks