+ Reply to Thread
Results 1 to 3 of 3

Copy to another tab in same work book based on date and "confirmed"

  1. #1
    Registered User
    Join Date
    07-20-2015
    Location
    NYC
    MS-Off Ver
    2010
    Posts
    70

    Copy to another tab in same work book based on date and "confirmed"

    Hi,
    I was wondering if someone can please help me with this macro.
    I want to be able to copy items from both the yellow and the purple tab, on to the black tab.
    Here's what's needed.

    1) if I filter the yellow tab, in column I to a particular date(s) - column I
    and column L by "confirmed" only, that it moves that to the black tab.

    2) same thing for the yellow tab, but column G for the particular date(s)
    and column J for "confirmed"

    Can you please help me fix this macro so it does this, please? And thanks in advance.

    Cele
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Copy to another tab in same work book based on date and "confirmed"

    Hi Cele

    See if the Code in the attached does as you require.

    Click on these Buttons...no need to pre-filter anything.
    Buttons.jpg
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    07-20-2015
    Location
    NYC
    MS-Off Ver
    2010
    Posts
    70

    Re: Copy to another tab in same work book based on date and "confirmed"

    Hi,

    Can you please help me fix so that the attached form so it copying when filtering it start copying from the first row instead of the second please?

    Thanks

+ 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. Linking dates in a work book to "Outlook Calendar"?
    By MrBigStyx in forum Excel General
    Replies: 1
    Last Post: 08-19-2015, 02:17 PM
  2. Replies: 6
    Last Post: 12-08-2014, 01:28 AM
  3. [SOLVED] Copy multiple rows that contain a certain "name" in column "A" then paste it into new work
    By rschlot2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2013, 02:25 PM
  4. Replies: 1
    Last Post: 05-10-2006, 08:50 PM
  5. [SOLVED] it says "disk is full" when I try to save my excel work book
    By Lynn in forum Excel General
    Replies: 3
    Last Post: 09-01-2005, 04:05 PM
  6. Replies: 1
    Last Post: 07-04-2005, 05:05 AM
  7. Replies: 2
    Last Post: 04-20-2005, 09:06 PM

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