+ Reply to Thread
Results 1 to 4 of 4

Advance search filters and formatting of data

  1. #1
    Registered User
    Join Date
    10-07-2020
    Location
    new jersey
    MS-Off Ver
    2019
    Posts
    55

    Advance search filters and formatting of data

    Hi,

    I have a workbook containing the "Original data" Tab which I download from a website. This data is not formatted and I manually format the data in a new sheet named "Formatted Data".

    With this formatted data, I am trying to build the "Result" tab in which I have multiple search filters based on which I can populate data automatically under row 11 in the "Result" tab.

    For each cell of data, I have inserted comments.

    I have also attached example formatted data with example results.

    Please help.

    Regards,

    Haroon Khurshid
    Attached Files Attached Files

  2. #2
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: Advance search filters and formatting of data

    Hi Haroon,

    This is the first part of your required code ... What I don't understand is the filtration part, for example, 'profit rate' is coming from column Q but I can't see how 14992051409889900 became 3.12%, also "Time","Trigger","Indicator" are also not clear how they're being extracted from column H ... If you could give more explanation of the filter, perhaps we could manage something
    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  3. #3
    Registered User
    Join Date
    10-07-2020
    Location
    new jersey
    MS-Off Ver
    2019
    Posts
    55

    Re: Advance search filters and formatting of data

    Profit in source data should be like X.XX % instead of 1499205140988990. so it is 1.49% this is formatting issue. Moreover, "Time","Trigger", Indicator are extracted from Column H of the formatted data.

    Thanks for the code for formatting

  4. #4
    Registered User
    Join Date
    10-07-2020
    Location
    new jersey
    MS-Off Ver
    2019
    Posts
    55

    Re: Advance search filters and formatting of data

    I tried to write the code and it works but it's slow while I filter and need improvement. Forum is not letting me upload code that's why I uploaded code in a text file.


    Regards,
    Attached Files Attached Files

+ 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. in advance filters - automatic update from source info tab to other location tabs
    By Brother John in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2018, 03:27 PM
  2. Replies: 3
    Last Post: 07-25-2014, 03:43 AM
  3. Advance search and replace options
    By natebaseline in forum Excel General
    Replies: 2
    Last Post: 04-25-2014, 02:42 PM
  4. Advance Search and GoTo a cell that meets a certain search criteria
    By moatik in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2010, 04:01 PM
  5. advance filters Arows
    By DSJ in forum Excel General
    Replies: 1
    Last Post: 08-31-2007, 05:42 AM
  6. Replies: 1
    Last Post: 06-19-2006, 10:56 PM
  7. [SOLVED] How do I set up advance filters excel 2003
    By util in forum Excel General
    Replies: 2
    Last Post: 01-09-2006, 11:45 AM

Tags for this Thread

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