I am a new MSExcel user and have some questions.

Trying to automate a daily download that I bring into Excel. I am using a separate spreadsheet for my macros. A Hyperlink opens up the daily spreadsheet that I need to manipulate and automate.

Problem 1: the # of records varies from day to day.
Problem 2: multiple line headers throughout the download that need to be deleted

Thought about using an Advanced Filter to select range and delete based on Criteria. But, how do I use an Advanced Filter on my Master Macro spreadsheet to delete rows on another spreadsheet?