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