+ Reply to Thread
Results 1 to 6 of 6

Insert Row For Value Not Found

  1. 11-13-2009, 02:02 PM #1
    bdb1974
    bdb1974 is offline
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Insert Row For Value Not Found

    Hi all,

    I'm attempting to add to the following to insert a row for values it cannot find and insert the missing value into column A.

    Please Login or Register  to view this content.
    Therefore if the value "554500" from Column A on Sheet "Working_Yard" is not found on Sheet "Inventory_YARD" Then it will find on sheet 554499 or 554501 on Sheet "Inventory_YARD and Insert Below/Above and insert a row
    with the value "554500" into column A for the repective row.

    So I will end up with:
    Column A:
    554499
    554500 ' new row added w/value
    554501

    Any help is appreciated.

    Thanks,

    BDB
    Reply With QuoteRegister To Reply
  2. 11-13-2009, 03:03 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Insert Row For Value Not Found

    Easiest way...when value is missing...add at the bottom of the data set and resort the data. Is the data set a single column only?

    Something like this:
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 11-13-2009, 05:13 PM #3
    bdb1974
    bdb1974 is offline
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Re: Insert Row For Value Not Found

    JBeaucaire, Works Perfect !!
    The data is no limited to a single column. but to each row. I'd like to bring data from other columns.

    Could you show how I would do this using "For Each cell"?

    I'd like to bring data in as follows:

    from Working_Yard to Inventory_GUS
    col. B to col. C
    col. Y to col. D
    col. Z to col. F


    Thanks for all your help.

    BDB
    Last edited by bdb1974; 11-13-2009 at 05:15 PM.
    Reply With QuoteRegister To Reply
  4. 11-13-2009, 05:24 PM #4
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Insert Row For Value Not Found

    Sorry, I don't follow that. If this sheet is adding data to a data set that involves more than one column, you'll need to post up a sample workbook with enough data in it to represent the issues you want covered.

    There are several columns to deal with?
    All at once?
    One at a time?

    Include some before/after examples to make it clearest of all.

    =======
    Click GO ADVANCED and use the paperclip icon to post up your workbook.
    Reply With QuoteRegister To Reply
  5. 11-13-2009, 07:16 PM #5
    bdb1974
    bdb1974 is offline
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Re: Insert Row For Value Not Found

    Let me try & explain again.
    For each row a Cell value is added to Column A on Inventory_Yard sheet,
    I would like to have data from other columns for that Cell row also added
    to the Inventory_Yard.

    So if
    Column A:
    554499
    554501
    554500 is new value added to Inventory_Yard sheet
    then for the row that 554500 is found on Working_Yard sheet
    I'd like to have data from column B copied to C on Inventory Yard.
    from column y to D and from Z to F.

    Hopefull this clarify's what I'm asking.
    If not, I'll try and post an example which will probably not be til Monday.
    Thanks,

    BDB
    Reply With QuoteRegister To Reply
  6. 11-14-2009, 01:07 PM #6
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Insert Row For Value Not Found

    Maybe this:
    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 11-14-2009 at 01:09 PM.
    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)

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