i am a bit new to VBA coding and i have been having an issue
i have been trying to link an active cell after filtering through a data to a new sheet.
I would like to make it dynamic since the active cell would change from week to week
after sorting 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 i would like a to be linked in A2 in Sheet1
Any suggestions would be greatly appreciated
Thank you for your time.