Forum Discussion
need help on a formula
I am trying to use the response in one cell to react to the status for possible employees that spans multiple cells and move those responses to another worksheet within the same book. For example, i...
Hi Dan, I'm not quite sure I understand everything. If you want to move something somewhere, you would have to do it manually. Otherwise you can only do it via macros.
What I would suggest is to collect your data in a sheet and then display the data you want in "ready to schedule". You can use the FILTER() function for this.
I have created a small example file for you. Have a look at it and try to solve your task this way.
=FILTER(Data!A2:E21,Data!A2:A21="active")
