+ Reply to Thread
Results 1 to 4 of 4

Copy all records with same date to new sheet

Hybrid View

  1. #1
    Registered User
    Join Date
    03-20-2012
    Location
    cro
    MS-Off Ver
    Excel 2010
    Posts
    2

    Copy all records with same date to new sheet

    Hello, i have a problem.
    I have excel file with cell that containt date and time whet something was maid.
    I need code that will go true records and all records with same date put in new sheet. I dont know how to do this!
    Example is in attachment.
    Tnx for help!
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: Copy all records with same date to new sheet

    Select Column A.
    Goto
    Data=>Filter
    Select the down arrow
    Select text filters=>contains
    Enter what you want the filtered data to contain.

  3. #3
    Registered User
    Join Date
    03-20-2012
    Location
    cro
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Copy all records with same date to new sheet

    Dave, tnx a lot!
    i will try and let you know if i have result.
    Tnx once more!

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: Copy all records with same date to new sheet

    You can select the filtered data then copy and paste it.

+ 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