Re: [tdf-discuss] Combining data from 2 spreadsheets

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 <bmaree@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+unsubscribe@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+unsubscribe@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