Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2014
    Thanked 0 Times in 0 Posts

    How to update or copy data from master workbook (database file) to individual workbook files?


    Can someone guide me how to update data from one master data excel workbook to multiple excel workbooks kept in a single directory?

    for eg. Employee master has all the details of all employees with wages, allowances breakdown. At the year end when the wages are revised, we need to apply employees individual time sheets maintained in different wrorkbook files.

    This will be a great help for me. Employee Code will be a unique reverence between the files to check and update.

    Many Thanks

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Melbourne, Victoria, Australia
    Thanked 246 Times in 228 Posts
    The data in the employee time sheets could contain links to the relevant cells in the master worksheet. This may be quite straightforward to do except for the fact that each individual employee could then look inside the master workbook and find out what everyone is being paid. I would guess this is not something you actually want to happen.

    If you are keeping all of this in a single directory, is there any 'protection' of your data from prying eyes?

    I guess we will need more information from you to work out the best way to do what you require. A macro is likely to be the best solution if your data is to be kept secure but if you don't need security then simple links are much less labour intensive.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Posting Permissions

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