+ Reply to Thread
Results 1 to 3 of 3

Copy names in B downward as long as A is the same

  1. #1
    Registered User
    Join Date
    02-16-2019
    Location
    Shippensburg, PA
    MS-Off Ver
    2017
    Posts
    2

    Copy names in B downward as long as A is the same

    Ok here's what I need. If column B has a name in it, and the cell to the left of that name has a number (i.e. 2114) I need the name in the initial cell in column B copy/pasted into every cell in B as long as the 2114 is in the cell to the left in column A.
    I've provided a picture to show a bit more of what I'm talking about, as this is genuinely confusing me.
    There are a lot of names in B, most unique, but the corresponding number to the left of those names is the deciding factor of whether the names are copied into the corresponding cells to the right of that same number.
    Sorry if this is a choppy way of explaining my situation. Please feel free to ask questions.Screen Shot 2019-02-16 at 5.04.07 PM.png

  2. #2
    Registered User
    Join Date
    02-16-2019
    Location
    Shippensburg, PA
    MS-Off Ver
    2017
    Posts
    2

    Re: Copy names in B downward as long as A is the same

    NOTE: I [I]was[I] doing this manually, which is why the only real example is at the top, numbered 1-1876 with the corresponding name Cindy Lee Brooms.

  3. #3
    Registered User
    Join Date
    02-15-2019
    Location
    Oviedo, FL
    MS-Off Ver
    Office 365
    Posts
    7

    Re: Copy names in B downward as long as A is the same

    Well a really quick way would be to filter on Column A by that number then paste and fill down.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy Formula - downward on a column as well as on a row
    By AlexiAlex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2015, 08:20 AM
  2. Need to copy the data available in column B and paste the same in column A downward
    By Yuvaraj Vivek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2014, 08:20 AM
  3. [SOLVED] VBA - search specific value in cell and copy 10 lines (downward and sideward)
    By juicersz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2013, 01:33 AM
  4. Copy formulas downward within a range using VBA
    By PY_ in forum Excel General
    Replies: 3
    Last Post: 12-15-2010, 11:24 AM
  5. Names too long?
    By Linda RQ in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 08-08-2006, 09:50 PM
  6. [SOLVED] names in a long list
    By ferde in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2006, 09:00 PM
  7. [SOLVED] need to copy a long list of file names
    By gilcola in forum Excel General
    Replies: 6
    Last Post: 08-18-2005, 08:05 PM

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