help on a vlookup

  • Thread starter Thread starter shlomop
  • Start date Start date
S

shlomop

I have on sheet 1 a check register, (Date/Ck. No./Disc./Amount), and,
would like to make some kind of vlookup. that if the description i
(let say) MCI, should appear on sheet 2 the whole line from sheet 1
and if MCI appears on line 3, and line 9, it should appear on sheet 2
one under the other and so on
 
An easy way is just to sort and copy
or
use data>filter>autofilter and copy
or use a macro to do it for you.
 
thank you for tour respond, but, I would like that if I enter in shee
1, on line 30 MCI, it should appear on sheet 2 without I should have t
copy or sort.
 
Back
Top