+ Reply to Thread
Results 1 to 6 of 6

Adding ROW using 1 column as reference and another column for naming - BAD title

  1. #1
    Registered User
    Join Date
    09-22-2008
    Location
    Vancouver, WA
    Posts
    54

    Adding ROW using 1 column as reference and another column for naming - BAD title

    Hi Everyone,
    Trying to do some automation for my team at work.. I have an excel sheet ready to show but I cannot figure out how to upload in this space.

    I Basically need to use DATA in Column D of my file to add a ROW and then use Column C to name that new ROW added...

    File Here:
    https://www.dropbox.com/s/npl4d7d8u3...ta%20file.xlsx
    Last edited by dbondmelo; 11-21-2013 at 11:25 AM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Adding ROW using 1 column as reference and another column for naming - BAD title

    Please attach the file in this website itself...

    Here you go...

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Adding ROW using 1 column as reference and another column for naming - BAD title

    Hi dbondmelo

    This Code is in the attached and appears to do as you require...keyboard shortcut...CTRL + x
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by jaslake; 11-20-2013 at 11:40 AM.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Registered User
    Join Date
    09-22-2008
    Location
    Vancouver, WA
    Posts
    54

    Re: Adding ROW using 1 column as reference and another column for naming - BAD title

    Incredible! thanks a ton for the help.

  5. #5
    Registered User
    Join Date
    09-22-2008
    Location
    Vancouver, WA
    Posts
    54

    Re: Adding ROW using 1 column as reference and another column for naming - BAD title

    How do I mark the thread as SOLVED?

  6. #6
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Adding ROW using 1 column as reference and another column for naming - BAD title

    You're welcome...glad I could help. Thanks for the Rep.

    New quick method to mark as SOLVED
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:
    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ 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. Return the Title of a column if the column is the highest column with data
    By williamspage in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-22-2013, 10:05 AM
  2. adding a column with job title from othe rcolums
    By ln2012 in forum Excel General
    Replies: 2
    Last Post: 12-09-2012, 06:08 PM
  3. naming a column & naming a cell with a number
    By evanzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2008, 10:49 PM
  4. Adding column title
    By reena in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2006, 04:50 AM
  5. Adding a column with reference to another
    By charles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2005, 02: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