I am hopeless and not familiar with macro at all. I've been online for hours trying to figure this out but I need a lot of help. I have an excel spreadsheet named Master with the following information.
A B C D E F G H I
1 Last name First name Email Phone Rating Interests Date Pro Follow Up
2 Hill Jack ... ... M 4.0 ... ... ... ...
3 Hill Jill ... ... W 2.5 ... ... ... ...
and so on. I have about 200 rows and will be adding more constantly. The column I care about is E (Rating). I want to make a new spreadsheet based on every rating which will be ...
W 2.5, W 3.0, W 3.5, W 4.0, W 4.5, W 5.0+ and then 6 more but with M instead of W (M 2.5 ... M 5.0+). I want the new spreadsheets in the same workbook and named after the Rating. So all the W 2.5 would be in the 'W 2.5' sheet along with all the information in their row.
How can I do this? I am a total noob, don't even understand how to set up a macro and enter code or anything. Is anyone willing to help? I know it's simple and I've tried twice with other code and just don't get it. It's for my new job and they need it ASAP.
Also, if you have enough time, is there a way to actually exclude some of the columns of information in the new spreadsheets? I would only want columns A, B, C, D, E, and F to be copied over. But if that's super complicated it's fine the original way.
And I'll ask before hand...in case I type in W 2.3 (an invalid rating) can whatever code provided STILL make a new spreadsheet based on that rating? I'd like this to happen so I can see spreadsheets with accidentally incorrectly typed ratings and correct them vs it being kept in the Master sheet and never sorted. Sorry if this is of course going to be done. I know nothing about coding this stuff.
Thanks for saving my life/job in advance!! and could I see comments by the code? I want to learn! Just don't have time right this second.