+ Reply to Thread
Results 1 to 4 of 4

Insert Rows Conditionally

  1. #1
    Registered User
    Join Date
    09-09-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Insert Rows Conditionally

    I have a list of Suppliers and Primary postcodes.
    Say the postcode was BA the start 1 and end 3....that means that particular supplier covers postcodes BA1 BA2 BA3.

    I need to manipulate this data so instead of having "BA start 1" end 3 i have a row for each.

    I know i need a macro to do this as im proposing expanding the 35000 postcodes to an even bigger amount.

    I've attached a example doc.
    Attached Files Attached Files
    Last edited by samsonuk; 09-18-2013 at 11:38 AM.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Insert Rows Conditionally

    Maybe
    Please Login or Register  to view this content.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Registered User
    Join Date
    09-09-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Insert Rows Conditionally

    Thankyou this forum is awesome!!!! Works so well.

    I do have a second challenge for you i now want to add a duplicate row so say Supplier 1 does Roofing and Heating.

    I expand the all the data so for every supplier there is a row for a postcode and what vocation is done in that postcode.

    Assume each supplier does all vocations in its active postcodes

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Insert Rows Conditionally

    I'm not sure I understand. Perhaps you can attach a workbook with a before and after example.

+ 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. [SOLVED] Conditionally insert a duplicate row
    By acohen12 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-11-2013, 02:40 PM
  2. [SOLVED] Macro to conditionally insert rows and fill them
    By dproth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2013, 09:48 AM
  3. Conditionally insert rows, sum and average
    By menyanthe in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-10-2009, 04:54 AM
  4. How to remove blank rows, then insert blank row conditionally, PLUS error proof
    By GTS115 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2009, 11:39 AM
  5. [SOLVED] conditionally insert image
    By M John in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-05-2006, 08:50 AM

Tags for this Thread

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