Autofilter and copy data to another worksheet behaviour

[ronlaboa]

Hello everyone,

I have a workbook with a little VBA code that filters data on one sheet and copies visible data to another sheet, the criteria it uses to filter is a value from a text box on a user form.

The code seems to run fine when I have the sheet that I am copying from selected, but when I have the destination sheet selected and run the user form it does not work.

I have attached the workbook and the code is very simple, but can anyone please explain why it does not work when I have the destination sheet(report) selected ?

Thanks in advance for your help.

Matt

[Mumps1]

Try:
Public team As String, clerk As String, error As String

Please Login or Register  to view this content.

You have to fully qualify all the ranges with the sheet name, for example:

Please Login or Register  to view this content.

You were also missing the dots in

Please Login or Register  to view this content.

[SjonR]

like this:

Please Login or Register  to view this content.

End Sub