I have a excel and it has few columns with dropdown (to be filled), few numeric columns in required format, few hidden columns and a column where name of a person is given.
Column where persons name is populated may same name 4 times, 2 times, once, anything.
I have to create a output file which is by splitting file by persons name.
For example,
Below is my excel file.
Column E and F are drop down columns which requires input by user.
Based on Column F, split the file keeping formatting and dropdown setting everything as it is.
So output file for Arjun should have first 3 rows and so on.
And finally, emailing the file to Arjun and other users as per the data
| | | | | Input Data | | | | | | |
| A | B | C | D | E | F | F | H | J | K | L | M |
| 123 | James | Tier 3 | N/A | <<Select>> | <<Select>> | Arjun | Arjun | - | 533 | - | 4,205,311 |
| 21 | Danu | Tier 5: <$1B | N/A | <<Select>> | <<Select>> | Arjun | Arjun | - | - | - | - |
| 43 | priya | Untiered | N/A | <<Select>> | <<Select>> | Arjun | N/A | - | - | - | - |
| 543 | payal | Tier 4 | N/A | <<Select>> | <<Select>> | Chintan | Chintan | - | - | - | - |
| 6775 | prachi | Tier 4 | N/A | <<Select>> | <<Select>> | Raj | N/A | - | - | - | - |
| 788 | suni | Tier 5: <$1B | N/A | <<Select>> | <<Select>> | Raj | Raj | 3,358,956 | 527,239 | - | 104,637 |
| 976 | shina | Untiered | N/A | <<Select>> | <<Select>> | Raj | Raj | - | 10,065,595 | - | - |
| 234 | john | Tier 5: <$1B | N/A | <<Select>> | <<Select>> | Riaan | Riaan | 8,092,137 | 510,876 | - | 5,168,328 |
