Mar 26 2019 09:15 AM - edited Mar 26 2019 09:19 AM
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
Mar 26 2019 09:54 AM
Mar 27 2019 02:42 AM
@Twifoo Thanks for the response!
We use the status to give our figures each day, so preferably I'd like them to remain
Mar 27 2019 03:07 AM
Mar 28 2019 03:51 AM
@Twifoo I only need the completed in tab1 to show as workable in tab2, the other 'statuses' are not needed.
Work1 Tab1 Workable, would show as Blank on Tab2
Work1 Tab1 InProg, would show as Blank on Tab2
Wark1 Tab1 Completed, would show as Workable on Tab2
Mar 28 2019 04:02 AM
Mar 28 2019 04:32 AM
@Twifoo Thanks, I'm having issues with it returns just '0', I have amended the sheet names and adjusted some of the cells etc but I'm still have issues.
I have attached some pictures for you to see, although they only show as workable on the screen grab further down there are some completed
Mar 28 2019 06:52 AM
Mar 28 2019 09:53 AM
Mar 29 2019 02:00 AM - edited Mar 29 2019 02:03 AM
@Twifoo There's nothing to attach, that's all there is.
The only thing I didn't add is that there's a dropdown list to select from Workable, InProg and Completed.
When I enter the formula I get this message
Mar 29 2019 02:45 AM
Mar 29 2019 02:58 AM
@Twifoo It's not a formula it's done via the data validation list option, if it makes a difference the list is kepted in STATS (sheet name) Completed (A40), InProg (A41) and Workable (A42)
Mar 29 2019 03:06 AM
Mar 29 2019 03:51 AM
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.
Mar 29 2019 03:59 AM
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?