you gotta be kiddin'?
OK, first of all, I've mocked up my instructions. Here is a correct order:
(1) Somewhere in your sheet, e.g. in E1 put "Header1" (or whatever the header is, e.g. "Medical Record Number")
(2) In E2 enter the criterion, e.g. 1111 (the filtered number)
(3) GoTo Data=>Advanced Filter
(4) Click into 'List Range', Select A1:C10
(5) Click into 'Criteria range', Select E1:E2
(6) Check "Copy to another location", select 'Copy To' range, e.g. G1 in the same sheet
(7) Hammer down on Enter
of course I select cells as the user interface requires you to do so. (In fact, you could type in the addresses, but why not use the offered refEdit control?)
In VBA, I would never-ever-never select any cells:
Dim rg As Range
Dim lNumber As Long
Let lNumber = 1111
Set rg = .Range("A1", .[c65536].End(3))
.[E1] = "Header1"
.[E2] = lNumber
rg.AdvancedFilter Action:=xlFilterCopy, _
P.S. Seeing the OPs response, I was off target anyway...