+ Reply to Thread
Results 1 to 3 of 3

Sort row data on another sheet and into different columns based on criteria

  1. #1
    Registered User
    Join Date
    02-27-2021
    Location
    Barcelona, Spain
    MS-Off Ver
    2010
    Posts
    1

    Sort row data on another sheet and into different columns based on criteria

    Hello everyone,
    I've been looking by several posts here and around, to find a solution about how to sort out using a VBA code to copy from a main list, to a secondary sheet where there are 2 different ranges classified as Expenditures and Incomes. Each range contains several columns with the reference of the product and other data.
    I'd be interested to do as this way instead of using filters (which only show a single list) to make more comprehensive the data of concrete periods, considering the main list comes out from a previous advanced filter. Also I'd like to know if there are any solution to skip certain colums which don't apply either in one or another range but they apply in the opposite range. I think in the attached file will be easier to understand, the example of the desirable output of the macro is located in the Sheet2.
    The most similar example I've found is to sort out the data contained in a main list into different sheets instead of dividing a secondary sheet into several ranges (in that case just 2).

    The code I've been working and trying with is this:

    Please Login or Register  to view this content.
    I hope you can help, any suggestions will be welcome. So thank you very much in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,427

    Re: Sort row data on another sheet and into different columns based on criteria

    Try
    Please Login or Register  to view this content.

  3. #3
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,601

    Re: Sort row data on another sheet and into different columns based on criteria

    Hi JMargarit & welcome to the forum

    This is another approach using Advanced Filter ...
    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

+ 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] Sort data to new sheet based on criteria
    By SPAAARK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2019, 11:30 PM
  2. Copying columns of data from one sheet to another based on multiple criteria
    By Dkristensen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2017, 11:43 AM
  3. Replies: 6
    Last Post: 12-13-2016, 03:06 PM
  4. Adjusted question - Copy data to 2nd sheet based on criteria and sort
    By ALWETTA in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-02-2015, 10:55 AM
  5. Replies: 0
    Last Post: 03-01-2015, 01:56 PM
  6. [SOLVED] Macro to code the Data set in another sheet to append in columns based on Criteria
    By anchuri_chaitanya in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-10-2012, 11:41 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