create sheets within a worksheet based on call value
Hi
I searched on this forum and could find the results for above heading. Although, my question is a little more than that.
Is it possible to have mutiple sheets created within a worksheet, based on values in a column. Now 2 or more cells may have same value within the same column, I want one sheets created if the values are repetitive. e.g if 'nolan' appears in the column 6 times, i want only one sheet created with name 'nolan'.
Also i want all the 6 Rows (which have nolan in them) data to be copied to this newly created sheet 'nolan'. Attached is a test file with data.
searched quite a lot but was unable to find and finally came across this forum where i actually wanted to ask ! :). I am not an expert in excel, just fyi.
please let me know.
Attachment | Size |
---|---|
test file.xlsx | 11.37 KB |
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago