+ Reply to Thread
Results 1 to 4 of 4

Copy data to different sheet based on filter and add total rows

  1. #1
    Registered User
    Join Date
    04-23-2012
    Location
    Greensboro NC
    MS-Off Ver
    Excel 2013, 2016
    Posts
    6

    Copy data to different sheet based on filter and add total rows

    Hi,

    I have a sheet where data is being populated using SAP report. Once the data is populated, i have to copy data from the main area to another based on a filter selection and add the total Rows. As the rows are not fixed and SAP can populate the rows based on available records, I have to do this using macro.

    Can we achieve this, I have attached the example sheet, help me.
    if you see the example, data from sheet 1 is copied toexample.xlsx sheet 2 based on filter criteria Air Conditioners & Electrical Equipment

    Any Kind of help is appreciated.

    thanks,
    ravi.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy data to different sheet based on filter and add total rows

    This may not be exactly what you want, but does it help?

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-23-2012
    Location
    Greensboro NC
    MS-Off Ver
    Excel 2013, 2016
    Posts
    6

    Re: Copy data to different sheet based on filter and add total rows

    Hi John,
    Wow that helps. Bang on target.

    Thanks a lot.

    regards,
    ravi.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy data to different sheet based on filter and add total rows

    You're welcome. Glad to hear it works for you and thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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