Using Advanced Filter
How would you make the CopyToRange dynamic?
Per the code below it works fine, but instead of a static "J7:CF7" I need CF to be able to expand to the furthest right column in Row 7 that holds a value.
For instance sometimes it is J7:CF7, othertimes it is J7:FD7
Thanks for any help with this