Results 1 to 4 of 4

Thread: Merge data

  1. #1
    Join Date
    Dec 2003
    Posts
    138

    Unanswered: Merge data

    Is it possible to merge data from an excel spreadsheet such as employee names and merge them in to another spread sheet such as an employee time sheet that is in excel. I would like it to work like mail merge with Word only from Excel to excel.

  2. #2
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116
    Nothing like mail merge other than writing a macro. Do the two files have the same layout? You can't copy/paste

    HTH
    texasalynn

  3. #3
    Join Date
    Oct 2003
    Location
    London
    Posts
    341
    One way that this may be possible is to use the following formula,

    ='Location of document \ [documentname.xls]Sheet1'!A1

    i.e.

    ='C:\My Documents\[Book1.xls]Sheet1'!R3C3

    This will only update everytime you refresh or when you have both documents open at the same time.

    Christy

  4. #4
    Join Date
    Feb 2004
    Location
    USA - California
    Posts
    21
    LOOKUP tables might bring the data in for you. Probably a vertical lookup VLOOKUP where your employee name spreadsheet is your lookup range and has to be displayed alpabetically. I am not a lookup expert by anymeans but have used them sucessfully for many simple "merges" in excel. Check the help files in excel on them and if you want to explore it more, email me. I'll help the best that I can.
    Melinda

Posting Permissions

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