Forum Discussion
Excel progression tabs / wording
Hello community, I'd greatly appreciate a helping hand if possible!
I have an Excel file with a vast amount of data, I have created separate tabs for work progression.
In the first tab I have a dropdown for 'Workable, InProg and Completed' I am looking to copy the status of 'Completed' over to the second tab and for this to then show as 'Workable', as this will enable a different group of people to work on the second tab.
I would like this all automated, so when person A updated the cell to 'Completed' on tab 1 it goes over to tab 2 as 'Workable'
If anyone has some ideas I'd be grateful.
Many Thanks,
L
15 Replies
V and H lookups become slow.
I would put a button on the forms and allow the people to use the honor system when they complete it. The button will populate the main form back. If you have as many tabs as I am thinking the sheet will become unworkable due to the amount of lookups when changing data. Just give them an IM DONE button. Heck you can even add in the start time of the tab they open and the finish time when they hit the button and if you want to get real high speed you can capture (input box) the employees id info.
Thanks for the response.
I just needed something like =INFORCE!B2 so it shows the status from the dropdown in 'Exited Payments' but I only need the completed to show.
I thought the VLOOKUP needed the same data in in the left to work?
- What if tab 1 is workable, in progress, or blank?
- If Work1 in Tab1 is Completed, Work1 in Tab2 is Workable. What I want to clarify are these:
1. If Work1 in Tab1 is Workable, what will Work1 in Tab2 be?
2. If Work1 in Tab1 is In Progress, what will Work1 in Tab2 be?
3. If Work1 in Tab1 is Blank, what will Work1 in Tab2 be?
