Thanks, that worked great! One final question ... each row on each sheet is
linked back to the same row in the master worksheet. When I type the name of
an employee on any row in the Master, it is automatically carried into the
same row of all the sheets in this workbook. The formula didn't carry over
to the new row that was added. Is there a way to add the new rows to each
sheet simultaneously that also copies down the formula at the same time?
Otherwise, I will still have to go into each sheet and copy the formula down
into the new row before I add the new name to the Master sheet. Thanks for
the help!

"Stringer" wrote:


Group the sheets by selecting the first sheet then pressing shift and
select the last sheet the sheets are now grouped and you can insert a
row to all the sheets at once,
be sure to ungroup the sheets again by right clicking on a sheets tab
and selecting "Ungroup sheets"
You can also select different sheets by pressing the Ctrl key and
selecting different sheets


--
Stringer
------------------------------------------------------------------------
Stringer's Profile: http://www.thecodecage.com/forumz/member.php?userid=117
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65022