Hello, friends!

Let's say I have the following code:

Private Sub Finished_Click() 
     
    Range("B1:B2").Select 
    Selection.Copy 
     
    Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial _ 
    Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True
  
  End Sub
I need to *Copy* the B1:B2 range from a sheet called Invoices, and *PasteSpecial* it into a sheet called Database. I'm new to VBA, so forgive my ignorance... But where do I specify in the code that I want to work with specific sheets? I've attempted to enter

Sheets("Database").Select
after the 

Selection.Copy
line, with no success...

I've also attempted to add the

Sheets("Database")
part into the PasteSpecial line --with, of course, no success.

How can I do this? Any help would be greatly appreciated.

Bubbis Thedog

(P.S. I help others on Excel forums as well. I'm not selfish!)