+ Reply to Thread
Results 1 to 3 of 3

Dynamic VBA that picks up filtered data which is daily updated.

  1. #1
    Registered User
    Join Date
    07-26-2020
    Location
    Toronto, Canada
    MS-Off Ver
    Office 365
    Posts
    2

    Dynamic VBA that picks up filtered data which is daily updated.

    Hi there,
    I am a bit new to VBA coding.
    I have been trying to link an active cell after filtering through a data that is from a power query that needs to be updated daily.
    Hence the row and column numbers change each time the query gets an update.
    I will like to create a dynamic code since the active cell would change from day to day.
    The data i wanted to copy from the query are usually easily filtered.
    after filtering through a data i stored the active cell by the code below

    Please Login or Register  to view this content.
    then i want to link that active cell to a new sheet in A2 with a sheet name "Sheet1" which i followed up with this code
    Please Login or Register  to view this content.
    all of the above works out and I am having trouble in the final step where for example if the data I need is in A423846 in the data tab after being filtered, I would type in =Data!A423846 in A1 of "Sheet1".
    In the next day that data tab would update and the data in A423846 would move to A423850. This is an example it might move 2 to 5 columns down.

    I would have to filter the data tab every single week to find a specific point and where the data starts.

    a sheet is attached with VBA code and the data that i am dealing with for further clarification

    Any suggestions would be greatly appreciated

    Thank you for your time.
    Attached Files Attached Files
    Last edited by Raeab; 07-26-2020 at 05:58 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: Dynamic VBA that picks up filtered data which is daily updated.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-26-2020
    Location
    Toronto, Canada
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Dynamic VBA that picks up filtered data which is daily updated.

    Thanks a lot ikboy. that worked like a charm.

    really appreciated.

+ 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. Need updated Sum when data is filtered
    By Zed.jpeg in forum Office 365
    Replies: 2
    Last Post: 01-11-2020, 02:14 AM
  2. [SOLVED] Filtering table daily, and printing the filtered data
    By resiexfor in forum Excel General
    Replies: 8
    Last Post: 01-14-2019, 11:38 AM
  3. Replies: 13
    Last Post: 01-14-2016, 04:19 PM
  4. Replies: 12
    Last Post: 11-03-2015, 04:54 PM
  5. dynamic pie chart labels not updated with new data
    By Flembo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-13-2009, 07:11 AM
  6. Replies: 2
    Last Post: 07-10-2006, 03:04 PM
  7. How to link a daily updated table data on website to Excel?
    By heatwave in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-08-2005, 08:50 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