+ Reply to Thread
Results 1 to 11 of 11

Match names between two sheets

Hybrid View

JulieH Match names between two sheets 10-28-2012, 04:43 PM
jeffreybrown Re: How to link 2 spreadsheets 10-28-2012, 04:48 PM
JulieH Re: Match names between two... 10-28-2012, 05:14 PM
jeffreybrown Re: Match names between two... 10-28-2012, 05:27 PM
Pete_UK Re: Match names between two... 10-28-2012, 05:31 PM
JulieH Re: Match names between two... 10-28-2012, 05:32 PM
JulieH Re: Match names between two... 10-28-2012, 05:37 PM
Pete_UK Re: Match names between two... 10-28-2012, 06:08 PM
JulieH Re: Match names between two... 11-02-2012, 11:30 AM
jeffreybrown Re: Match names between two... 11-03-2012, 10:10 PM
JulieH Re: Match names between two... 11-05-2012, 04:54 PM
  1. #1
    Registered User
    Join Date
    10-28-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Match names between two sheets

    Hello Pete!

    I'm lost at this part "Sheet2, column A, press <end> followed by down-arrow then down-arrow to move to the next empty cell then press <enter> to paste your list in there."

    It would be easier if I have sample spreadsheets, I will post it when I have it ready.

    Thank your for your help.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,423

    Re: Match names between two sheets

    That part means to select Sheet2 by clicking on the tab (you were in Sheet1, where you copied the visible names), then ensure that you are in column A (where your other names are located), then press the <End> key and then the down-arrow key, (which will move you to the bottom cell containing data) then press the down-arrow key once more (which will take you into the next empty cell below your existing names), and then press the <Enter> key (which will paste the names that were filtered on Sheet1, i.e. the missing names, below your existing names on Sheet2.

    Hope this helps.

    Pete

+ 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