+ Reply to Thread
Results 1 to 3 of 3

Adding Multiple Rows Depending on Column Content

  1. #1
    Forum Contributor
    Join Date
    07-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    136

    Adding Multiple Rows Depending on Column Content

    Hello All. I am coming back once again to this forum that has helped me tremendously with other projects. I am hoping someone can help me out here I am totally stumped and not sure if excel has this capability to do what I need. Basically my distributor of automotive parts provides me with a spreadsheet of auto parts and their compatibility. I am trying to list some of these items in bulk.


    A sample of the list my distributor gives me can be found here: SampleOfProductData.xlsx


    I am trying to list in bulk to eBay. Ebays requirements for bulk upload for automotive compatibility is a pain in the rear. A sample of what they require can be found here LayoutNeeded.xlsx

    Is there any code that can be made to take the distributor’s spreadsheet and run a code that will put the in the requirement layout under the columns “relationships” and “relations_details” as ebay requires adding multiple rows per year make and model groups?

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Adding Multiple Rows Depending on Column Content

    See the attached workbook where I created a sheet named "Ebay Layout". I also created a button in your sheet "SmittyBiltBumpers" to start the creation of the Ebay layout.
    Here is the macro you will find in the workbook:
    Please Login or Register  to view this content.
    Hope this helps
    Attached Files Attached Files
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Forum Contributor
    Join Date
    07-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    136

    Re: Adding Multiple Rows Depending on Column Content

    What you have done is amazing. I cannot thank you enough. Pure genius. AMAZING!

    Quick question please see attachment. Since there are some many different combinations can the same thing be done with column application1 application2. This list all the capabilities/fits. Make Model Sub model Starting Year to End Year? Would this be easier for excel to look into those columns and pull that content directly? This would make less columns from the information I get.
    Attached Files Attached Files
    Last edited by ryanb4614; 04-24-2014 at 11:04 AM.

+ 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. Macros auto hiding of rows depending on cell content
    By nad23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2012, 12:40 PM
  2. [SOLVED] How to autofill a column with a cell content depending on content in another cell.
    By lul1971 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-17-2012, 12:33 PM
  3. [SOLVED] Return a specific column of data depending on the content of a cell
    By Herr Rommel in forum Excel General
    Replies: 2
    Last Post: 05-07-2012, 02:21 PM
  4. Creating a macro that duplicates content depending on a number in column A
    By webuxer in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 09-22-2011, 02:13 PM
  5. Hide rows depending on content...
    By Gord in forum Excel General
    Replies: 1
    Last Post: 05-12-2005, 05:06 AM

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