Macro runs slow automating it within a function, but works fine running it manually

I am manipulating some data and to speed things up i decided to create a function to copy the relevant rows to another spreadsheet.

i was having trouble getting the function to work but could not find any reason for it. I changed it into a macro instead and it works fine when i run it manually from the drop down menu.. here is my code

Please Login or Register  to view this content.

when i run the macro it is quick, and speeds up the calculations of my vba functions since it is only sorting through the relevant data. Problem is i want the macro to run automatically any time a user alters a cell because it may have to pull different data depending on what the user is asking for.

i figured i could do this by

Please Login or Register  to view this content.

but when i do it this way everything is slow as snails.

not sure what the issue is with copying rows, but it seems strange that it would not work as a function, and then also does not work right when i call it as a macro through a function. but works fine when i manually run it as a macro. has anyone experienced this?

I don't see why you need the Function. The actual code could run better if you didn't use Select & a Loop. Post a sample workbook