+ Reply to Thread
Results 1 to 2 of 2

Aligning data from two spreadsheets

  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    12

    Aligning data from two spreadsheets

    Hello everybody,

    Please help. I am trying to copy data from column N (Depot) within the "depot listing" sheet to column G (Depot) of the "jobs listing" sheet but only if the surname matches in column B "depot listing" to that of column D "jobs listing" sheet.
    The depot needs to be aligned with the appropriate surname with the ultimate aim of determining the Managers' Depot on the "jobs listing" sheet.
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Aligning data from two spreadsheets

    It's hard to say......... the example you provided does not show any matching surnames in either worksheet and also does not provide the desired results you are looking for

+ 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