Code in excel file to automatically run when manually copy pasting downloaded excel data

Hi All,
I am quite new to vba and have been trying to put together codes available online but unfortunately is not working due to my lack of background knowledge.

What I would like to do is whenever I download excel dataset with updated data (i.e. each month's data added) from the website & manually copy paste into my excel file (which I will be using for reporting purposes) into the worksheet named "All_Data", the code to check for 3 conditions (specialLookUp) should run automatically and the resulting subset must appear in Sheet2.

Initially I used just the Subroutine specialLookUp and it worked but when I copy pasted the downloaded data into "All_Data" Worksheet it stopped working, then I tried to add the Worksheet_change and other bits.

All of this code is in Module1.

Please help!

Here's the code:

Please Login or Register  to view this content.

ExcelerNew,

Welcome to the forum. We would really like to help you but please take a moment to read our Forum Rules.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Once you complied to this we can help you with your project.

For starters both the event macro's ( Change & Calculate) should be in the SheetModule of sheet All_Data.