I am hoping I can get this done without a macro as I have not written code in years but I'm pretty sure it will not be possible. Anyway, I have a spreadsheet that tracks sales opportunities based on odds. If it is high odds it belongs in the top section, decent odds the middle section, and low odds, the bottom section (these are the only three). These entries are pulled from a master sheet that is essentially a pull from a large DB and does very little organization on its own. This master sheet changes daily so I am constantly pulling new data in and old data is constantly falling out.
I would like to create a column that includes a 1, 2, or 3 on my sheet and when this number is changed, the entire row and associated formulas automatically move to the correct section. What would be especially helpful is if I could get it to move to the correct section and in a row that places it into descending order based on the revenue column.
I hope I explained this clearly and would greatly appreciate any assistance or advice. If I can get this done without a macro, I am all ears as I am a little fearful about something changing and being unable to fix it. Thanks in advance for your help.
Bookmarks