+ Reply to Thread
Results 1 to 4 of 4

filter using loops

  1. #1
    Registered User
    Join Date
    04-09-2015
    Location
    delhi
    MS-Off Ver
    7
    Posts
    15

    Post filter using loops

    Hello

    I have a sheet from which I need to import data into another file using vba.

    The condition is that it needs to pick up information only if there is a specific quantity listed under it.

    I'm attaching the source file and the output file. Please advise the best possible way to accomplish this task.

    Thank you

    Sahil
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: filter using loops

    Am i confused?
    You have uploaded two duplicate sheets with no information as to what you actually require!
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    04-09-2015
    Location
    delhi
    MS-Off Ver
    7
    Posts
    15

    Re: filter using loops

    My apologies.

    I uploaded the wrong source file by mistake.

    Attaching the correct file now.

    In simple terms, I just need to filter and paste the data for each order number from the source sheet along with the quantity in the output sheet.
    Attached Files Attached Files

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: filter using loops

    The condition is that it needs to pick up information only if there is a specific quantity listed under it.
    In simple terms, I just need to filter and paste the data for each order number from the source sheet along with the quantity in the output sheet.
    Nope...You still have given us no information as what you actually want to do...
    What specific quantity?
    Filter what?

    We cannot assist with code if we do not know what code to write...

    I suggest you upload a file with a before and after scenario depicting the required result and explaining in detail what the result is derived from...

+ 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. Loops within loops looping
    By Memphismark in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2017, 12:21 PM
  2. VBA Loops / IF
    By ddbroadhead92 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-28-2016, 11:16 AM
  3. [SOLVED] Help with do until loops.
    By etuckram in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-28-2013, 08:15 AM
  4. Do Loops
    By kathhying in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2011, 09:34 AM
  5. How I can use Loops
    By kumar28 in forum Excel General
    Replies: 1
    Last Post: 01-12-2009, 02:11 PM
  6. please help with Loops
    By jhahes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2005, 12:00 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