linking multiple worksheets and master completes next available li
 

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

linking multiple worksheets and master completes next available li
 

Maybe this is a option for you
http://www.rondebruin.nl/copy1.htm

Add a button on each employee sheet to copy to the database sheet

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"goverment employee" <goverment wrote in message
...
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

linking multiple worksheets and master completes next available li
 

Let's assume the employee sheets are named: Emp1, Emp2, ...
with data in cols A to C, from row2 down

In your summary sheet,
you have set-up simple link formulas in "blocks" such as these

In A2: =IF(Emp1!A2="","",Emp1!A2)
A2 copied across to C2, filled down say 10 rows to C11
(this brings over data from Emp1)

Then for the next block (get data from Emp2)
In A12: =IF(Emp2!A2="","",Emp2!A2)
A12 copied across to C12, filled down say 10 rows to C21
And so on, for each of the 6 employee sheets

With the above set-up in place, here's an easy way to then dynamically
converge the above into the final result that you seek, ie essentially remove
all the intervening blank rows and pack the results neatly together at the top

In D2: =IF(A2="","",ROW())
Leave D1 empty

In E2:
=IF(ROWS($1:1)COUNT($D:$D),"",INDEX(A:A,SMALL($D: $D,ROWS($1:1))))
Copy E2 to G2. Select D2:G2, copy down to cover the extent of the formulated
range in cols A to C. Minimize/hide cols A to D. Cols E to G will return the
required results.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:57
xdemechanik
---
"goverment employee" wrote:
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