+ Reply to Thread
Results 1 to 8 of 8

Filter value based on list and paste on new sheet with one blank row between each value

  1. #1
    Registered User
    Join Date
    05-23-2019
    Location
    Luxembourg
    MS-Off Ver
    2018
    Posts
    6

    Filter value based on list and paste on new sheet with one blank row between each value

    Hello,

    I am trying to perform a filtering operation based on values in another sheet and I cannot determine a correct VBA code.

    On sheet account number, there is account number
    On sheet summary, this is a global database
    Expected Output is the result I would like to have

    The VBA should be able to filter in column A of sheet "Summary" the values as from row 4 found in sheet "Account Number" and then paste it on sheet "Expected Output" as from row 6. After each ending row of value, we should have a blank line.

    I am trying to use a dynamic approach rather than static when performing the filter, for instance not using "Criteria1:="22221".

    Can you please help, attached is the excel workbook.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5,830

    Re: Filter value based on list and paste on new sheet with one blank row between each valu

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    05-23-2019
    Location
    Luxembourg
    MS-Off Ver
    2018
    Posts
    6

    Re: Filter value based on list and paste on new sheet with one blank row between each valu

    Hello Mumps1,

    Thank you very much for the solution, it worked.

    In case, I would like to use a second variable to perform the macro as per attached, can you please let me know how to perform the loop.

    Thank you
    Attached Files Attached Files
    Last edited by sharmaiii; 04-01-2020 at 12:00 PM.

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5,830

    Re: Filter value based on list and paste on new sheet with one blank row between each valu

    The link you posted doesn't work. To attach a file, follow the instructions in the yellow box at the top of this page.

  5. #5
    Registered User
    Join Date
    05-23-2019
    Location
    Luxembourg
    MS-Off Ver
    2018
    Posts
    6

    Re: Filter value based on list and paste on new sheet with one blank row between each valu

    I have attached the sample workbook.

    Thank you

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5,830

    Re: Filter value based on list and paste on new sheet with one blank row between each valu

    Try:
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    05-23-2019
    Location
    Luxembourg
    MS-Off Ver
    2018
    Posts
    6

    Re: Filter value based on list and paste on new sheet with one blank row between each valu

    Hello Mumps1,

    Thank you for help and support, the code worked perfectly

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5,830

    Re: Filter value based on list and paste on new sheet with one blank row between each valu

    My pleasure.

+ 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. Filter copy paste data based on sheet name
    By kannan1847 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-31-2015, 01:58 PM
  2. [SOLVED] Filter the original sheet based on comparison and paste the results onto a new sheet
    By aviatecar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2014, 12:45 PM
  3. [SOLVED] Filter/Copy based sheet name paste non adjacent columns
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2014, 06:16 AM
  4. VBA: Copy non-blank and paste to separate sheet ONLY blank cells (running list)
    By brolsen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2014, 03:34 PM
  5. [SOLVED] Copy & Paste to another sheet based on criteria on next blank row
    By Webbers in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-06-2013, 04:09 PM
  6. VBA code need for advance filter non blank cells, paste data to another sheet
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2012, 12:15 PM
  7. Replies: 15
    Last Post: 08-07-2012, 03:06 PM

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