+ Reply to Thread
Results 1 to 2 of 2

linking worksheets to auto-insert rows

  1. #1
    Registered User
    Join Date
    02-28-2007
    Posts
    3

    linking worksheets to auto-insert rows

    I have multiple worksheets in one file that track various aspects of our employees information. One shows their generic human resources type of info, one shows their payroll information, one tracks their time off, one tracks their benefit information. When I add an employee I must go into all four spreadsheets and insert the row and put in all their info, much of which is duplicated from worksheet to worksheet (name, soc sec #, date of birth, date of hire, etc.). Is their a way to link the spreadsheets so that anytime I insert a row into the human resources spreadsheet (since that sheet is alphabetical, I insert rows), the other three worksheets will automatically insert a row as well and copy in the basic information?
    Thanks in advance for any insights.

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,071
    Hi,

    Yes ... with Excel everything is feasible ...
    But this feature depends pretty much on the way you have built your worksheets ... If you have, say, a variables worksheet, which feeds all the subsequent sheets using linked formulas, it becomes feasible since each piece of information is always located in the same cell ... otherwise it is a nightmare ...
    HTH
    Carim


    Top Excel Links

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1