Spread New Hires to Department/Positions

Greetings Community,

My first day here please be patient until I master the rules!

My challenge:

Large number new candidates hired and need to be set up to their respective positions on attached work sheet. I want to enter data only on first sheet and excel to add their entire row information to their position work sheet. that is if the question in column "O" accept? is "YES" This I know is very simple and silly for you excel gurus! but it means a great deal to me if you let me know what I need to do.

Thank you,

Do you want the data to be transferred to the position sheet once all the data has been entered in the first sheet (that is, by click of a button)? Or should it be transferred as soon as one row is entered?

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.