Transfer data from one sheet to another when Sheet is not active

[egrospe17]

Hi there,

I have a userform that will transfer data from one sheet to another based on a cell criteria with a click of a button. My code works well however, since the sheet the data is being transferred to is not the current active sheet, it does not transfer the data. I need to have the other sheet (where the data is being transferred from) the default active sheet for the end user.

Is there a way that the data would transfer from one sheet to another even though the other sheet is not active?

here's my code:

Please Login or Register  to view this content.

Thank you for your help.

[AlphaFrog]

Add the worksheet qualifier sht. in front of all the Range references like this...

Please Login or Register  to view this content.

[egrospe17]

Add the worksheet qualifier sht. in front of all the Range references like this...

Please Login or Register  to view this content.

Thank you AlphaFrog! That solved my problem!

Cheers!