+ Reply to Thread
Results 1 to 4 of 4

macro to copy specific data from one sheet and paste into two sheets

  1. #1
    Registered User
    Join Date
    03-14-2009
    Location
    Victoria
    MS-Off Ver
    Excel 2000
    Posts
    8

    macro to copy specific data from one sheet and paste into two sheets

    Hi,
    Wondering if anyone can help me with this - I have a WB with three worksheets (actually, there are several more but only three are used for what I really need help with).

    There's one sheet that has a list of customers (this is updated very frequently). These customers are either ‘New’ or ‘Existing (as listed in a corresponding column) - would it be possible to have a macro that, when run, will place a copy of existing customers into a second worksheet (“view list – new”), and a copy of new customers into a third worksheet (“view list – existing”), with the main worksheet still listing both existing and new customers.

    As the main sheet that lists all customers is updated very frequently (with customers being added and removed throughout the day), would it be possible to clear all contents of the other two sheets that each list of 'existing' and 'new' customers will be copied into, before the two lists are copied into each of the two sheets (just to ensure there isn’t any data in there from the previous time each list was copied in).

    I’ve given this a go via the ‘record macro’ function - some users of this WB use excel 2000, and others use excel 2007, but it only seems to work on excel 2007 (which is what it was recorded on)…

    Would really appreciate some help with this…
    Attached Files Attached Files
    Last edited by Shogun; 03-26-2009 at 04:56 AM. Reason: solved

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: macro to copy specific data from one sheet and paste into two sheets

    Quote Originally Posted by Shogun View Post
    There's one sheet that has a list of customers (this is updated very frequently). These customers are either ‘New’ or ‘Existing (as listed in a corresponding column) - would it be possible to have a macro that, when run, will place a copy of existing customers into a second worksheet (“view list – new”), and a copy of new customers into a third worksheet (“view list – existing”), with the main worksheet still listing both existing and new customers.
    Did you state that correctly? You want the "new" customers on a blank sheet called "view listing - existing"? That sounds backwards....
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: macro to copy specific data from one sheet and paste into two sheets

    This macro I believe does what you want:
    Please Login or Register  to view this content.
    If you really didn't state that original request backwards, you'll want to reverse the two red values in the code above.

    I added a quick "button" you can use to do the parsing quickly when wanted.
    Attached Files Attached Files
    Last edited by JBeaucaire; 03-24-2009 at 07:27 AM.

  4. #4
    Registered User
    Join Date
    03-14-2009
    Location
    Victoria
    MS-Off Ver
    Excel 2000
    Posts
    8

    Re: macro to copy specific data from one sheet and paste into two sheets

    Thanks so much for that, really appreciate your help - it works perfect!
    Oh yes, it was a typo and I did have 'new' and 'existing' around the wrong way

    Thanks again...

+ 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