Results 1 to 6 of 6

Thread: VBA Code needed to insert rows based on pricepoints

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-23-2018, 05:00 PM #1
    dougs522
    dougs522 is offline
    VBAX Regular
    Joined
    Aug 2018
    Posts
    6
    Location

    VBA Code needed to insert rows based on pricepoints

    Hi,
    I have attached a cut down version of the data I'm trying to sort.
    Column A has product, and column B has a Sell price.
    I'm stuck on creating the code to look through the list of prices in column B, and insert blank rows to seperate the list into set pricegroups.
    Eg. 0 - 499 / 500 - 799 / 800 - 999 / 1000 - 1499 / 1500 - 1999 / 2000 - 2499 / 2500 - 2999 / 3000 - 3499 / 3500 - 3999 / 4000 - 4499 / 4500 - 4999

    Any help or advice would be greatly appreciated.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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