unansweredSplit data into tables in multiple worksheets based on column

1 week 4 days ago #2655 by soo.kim
I found the below vba code that can partially accomplish what I am trying to do. 
How to split data into multiple worksheets based on column in Excel?

Each month I have a large exported data that I need convert into a table and then need to split into multiple worksheets based on the first column of the table. The worksheet names are based on the value from the first column. I would like to have the data pasted into the sheets starting from cell A10 instead of A1. 
Here is what I would like to accomplish:
1. Existing sheets: (1) Data export converted into table & (2) Summary with list of all sheets that has hyperlinks to each of the multiple sheets & (3-20) sheets named based on first column of table
2. Split data based on column value from first column in table into the multiple sheets (based on column value). Over-ride the existing data in those multiple sheets. Split data should begin on cell A10, the headers should be on row 10 (A10:G10)
3. Insert a macro in column F so that double clicking will insert a checkmark (tickmark)
4. If there is a checkmark(tickmark) in column F the adjacent cell in G10 should be updated to text "cleared"
5. Add a column H and insert a drop-down list into the data cells in column H
6. each new month clear previous month's data and inputs and replace with current month's data

Any help is greatly appreciated. Thank you.

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun