Hi Bashar You probably should be asking questions like this on the users list, or in one of the forums (see http://www.libreoffice.org/get-help/) but the general solution to this is to use Insert > Link to External Data to link to the second spreadsheet where you must have identified the target data by a data range. You probably will want to do this on a separate worksheet. Then use VLOOKUP using employee ID to get the account numbers. You can get more help for this in Help or from the link I have given you.
Hope that helps Tony On 19 January 2014 09:49, Bashar Maree <bma...@gmail.com> wrote: > At my workplace the salaries are usually calculated in a simple Calc sheet > that has 3 columns; the employee ID, his name and the salary amount. The > number of paid employees ranges, month to month, between 40 to 100. > We now need to add a bank account number to this list. The account numbers > are in a separate spreadsheet that has 2 columns employee ID and his > account number. This second spreadsheet has over 1500 entries in it. Is > there a way to automate filling the account column in the first sheet from > the second by using the employee IDs. Thank you. > > Regards, > -- > Bashar Maree > > -- > To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.documentfoundation.org/www/discuss/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
