+ Reply to Thread
Results 1 to 8 of 8

extract data based on last date

  1. #1
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    extract data based on last date

    hello
    I have this simple sample contains a few data but my real file contain at least 1000 rows so the data begins from a2: e what I would when run any macro do that showing the result from h2:l
    thanks in advance
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    528

    Re: extract data based on last date

    Very short and poor description of what to do. Maybe it will be ok.
    Please Login or Register  to view this content.
    Best Regards,
    Maras.

  3. #3
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: extract data based on last date

    perfect ! but I have a problem in format date my date is this dd/mm/yyyy ,but after filter data give me this mm/dd/yy ,may you fix it ,please"
    thanks
    Last edited by ABDELFATTA; 01-12-2021 at 11:48 AM.

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: extract data based on last date

    Please try

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: extract data based on last date

    great work ! @ BO-RY many thanks for your code

  6. #6
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    528

    Re: extract data based on last date

    @ABDELFATTA, I think it will be enough.
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: extract data based on last date

    thanks @maras now it's been fixed

  8. #8
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: extract data based on last date

    @ BO-RY & maras ,could you adjust the code as in my a new file, please ? sometimes I have repeated the last day so what I want to be summing the values for instance about the last date for brand " camera" it repeats twice sometimes more three or four times ... and son
    02/01/2020 camera ca-1001 chi 20
    then when I filter should be like this
    02/01/2020 camera ca-1001 chi 40
    I put the result in attached file about duplicated last date
    Attached Files Attached Files
    Last edited by ABDELFATTA; 01-21-2021 at 06:19 AM.

+ 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] Macro to extract data based on date range and values
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 36
    Last Post: 05-08-2020, 10:44 AM
  2. [SOLVED] How to extract sumifs data based on date
    By arsyan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-16-2019, 12:28 PM
  3. Replies: 2
    Last Post: 10-18-2017, 02:12 PM
  4. How to extract data from another worksheet based on Start Date, End Date
    By xBadBoi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2016, 03:20 PM
  5. Extract Data based on Date
    By ngor3431 in forum Excel General
    Replies: 1
    Last Post: 05-31-2012, 09:03 PM
  6. Extract data based on date?
    By peejayw in forum Excel General
    Replies: 7
    Last Post: 12-03-2008, 09:54 AM
  7. how to extract data based on date
    By vidhya in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2005, 06:05 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