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
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
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.
Bookmarks