linking multiple worksheets and master completes next available li

G

goverment employee

I have searched these postings and can not find my answer. If someone can
point me in the correct directions I would really appreciate it. I have six
different worksheets, one for each employee, and all six have the same
formating and same type of information in each. I want the entry into an
individual employees worksheet to reflect on the next available line on the
master worksheet. I have been able to accomplish linking an individual
employees worksheet to master but only within a range of rows for each
employees. For example employee one will link to the master in rows 1 -100.
What I wish to happen is if someone is entered on employees one worksheet it
is entered on row one of the master, then if employee two has four entries
onto their indiviudal worksheet then row 2 - 5 will be completed on the
master. Can someone help with the formula to do this please. thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top