Forum Discussion

Copper Contributor

Mar 26, 2019

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 hav...

excel

Formulas and Functions

Robert_Golobek

Copper Contributor

Mar 29, 2019

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.

Loobc

Copper Contributor

Mar 29, 2019

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?