I have an excel spreadsheet with 2 tabs. One is Opportunities and one is Last Planner.
On the opportunities tab I have a column called Status and a column called Opportunity. Example:
(A1)............... (B1)
Opportunity | Status
-------------------------------------------------
Compare Life | Moved to last planner
My last planner tab has a column called Project and a column called Opportunity. Example:
(A1)................. (B1)
Project...... | Opportunity
-------------------------------------------------
Project #1 |
Project #2 |
Project #3 |
If someone selects "moved to last planner" on the "Opportunities" tab from the "Status" column drop down list, I want the opportunity in that row to copy over to the last planner tab in the first available Project # row. By availble, I mean, a project that was not already assigned to another opportunity.
Hope this makes sense. TIA
On the opportunities tab I have a column called Status and a column called Opportunity. Example:
(A1)............... (B1)
Opportunity | Status
-------------------------------------------------
Compare Life | Moved to last planner
My last planner tab has a column called Project and a column called Opportunity. Example:
(A1)................. (B1)
Project...... | Opportunity
-------------------------------------------------
Project #1 |
Project #2 |
Project #3 |
If someone selects "moved to last planner" on the "Opportunities" tab from the "Status" column drop down list, I want the opportunity in that row to copy over to the last planner tab in the first available Project # row. By availble, I mean, a project that was not already assigned to another opportunity.
Hope this makes sense. TIA
