+ Reply to Thread
Results 1 to 7 of 7

Auto Fill Based on Column Information

  1. 05-19-2016, 09:13 AM #1
    kimmycoop910
    kimmycoop910 is offline
    Registered User
    Join Date
    04-21-2016
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2013
    Posts
    22

    Auto Fill Based on Column Information

    I have a database that has information listed in thousands of rows (See column B below). I need the description of that data to populate in the column (A) beside it. I can copy the description data in column A and drag it down but I'm dealing with 50,000+ rows so I'm looking for a quicker, more automated way to do so if possible. Any help is greatly apprecaiated!

    COLUMN A COLUMN B
    Description Database Information

    Name Cieslak, Kimberly
    Email kcieslak@ddilink.com
    Phone 800-948-6293 x 7104
    Company Digital Designs, Inc.
    Title Vendor Enrollment Specialist
    City Charlotte
    State NC
    Reply With QuoteRegister To Reply
  2. 05-19-2016, 12:48 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Auto Fill Based on Column Information

    A sample spreadsheet would help a lot. Are you saying that you have data where you have complete information in Column A but sometimes the information in column B is blank and when it is, you want to copy the cell above it information down?
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
  3. 05-19-2016, 02:37 PM #3
    kimmycoop910
    kimmycoop910 is offline
    Registered User
    Join Date
    04-21-2016
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Auto Fill Based on Column Information

    The information is listed in column B and I need the description information in Column A so i can filter it and copy to another worksheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 05-19-2016, 03:21 PM #4
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Auto Fill Based on Column Information

    This is exactly backwards from the way I imagined it. If this is a one time thing, then I suggest you enter the following formula in cell A10 =IF(ISBLANK(A2),"",A2) Then copy it down to the last line of data.

    I found one fly in the ointment in Cell B57. It had the word "Today" in it. The way I found it was that from row 50 onwards, Name was blank so I looked in that neighborhood. I don't know if you have other such anomalies in your extended data set.

    To fix it, I cleared the filter and removed the line. That will kick of a bunch of #REF! errors. Copy the formula form any cell above row 50 back down and everything will come out OK.

    Make sure when you copy to the other workbook, you paste as values.
    Reply With QuoteRegister To Reply
  5. 05-19-2016, 03:23 PM #5
    The_Snook
    The_Snook is offline
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2021
    Posts
    1,013

    Re: Auto Fill Based on Column Information

    Hi kimmycoop910,

    You could simply enter '=A2' in cell A10 and then highlight the range you would like it applied to (with A10 being the top cell selected) and use the fill down command (ctrl + D) to apply it. Copy and paste the data as values and use the find command (ctrl + F) to convert the 0's to blanks.

    Hope this helps.

    Snook
    Reply With QuoteRegister To Reply
  6. 05-20-2016, 08:30 AM #6
    kimmycoop910
    kimmycoop910 is offline
    Registered User
    Join Date
    04-21-2016
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Auto Fill Based on Column Information

    THANK YOU!!! This forum is awesome!
    Reply With QuoteRegister To Reply
  7. 05-20-2016, 08:31 AM #7
    kimmycoop910
    kimmycoop910 is offline
    Registered User
    Join Date
    04-21-2016
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Auto Fill Based on Column Information

    Thank you! That works perfectly!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] need to fill in rows based on column a information
    By AWITCHER in forum Excel General
    Replies: 4
    Last Post: 05-13-2015, 03:43 PM
  2. Auto fill information based off of drop down list
    By anorberg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2014, 03:55 PM
  3. Auto fill next column based on the selection from drop down
    By sumesh83 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-17-2012, 09:32 AM
  4. Auto fill column A sequentially for a given range, based on drop down selected in column D
    By Lindaxlsx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-10-2012, 12:55 PM
  5. Fill in a calendar schedule with information based on dates in a column
    By matten7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2012, 10:10 AM
  6. [SOLVED] Auto Fill Column with Date based on rows in other column
    By JOUIOUI in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2006, 01:35 PM
  7. [SOLVED] Auto-fill cell based on adjacent cell information..
    By sans in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-17-2005, 07: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1