Hi,

You may also create a pivot and drag the column which has Visa to the report
filter and then while you are on the report filter cell (in the pivot),
click on Show Pages. This will create a separate worksheet for every visa
number

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"hp" wrote in message
...
OK I have to analyze visa charges that are downloaded. The main data
needs
to be separated into different tab. So I need something that will look
for
each line with reference Visa #1 and return the independent lines even
though
the reference is the same. Similarily for Visa#2 through 50 on their own
tabs.....Would vlookup work? seem to be getting return of only data on the
first line. Can someone give me direction on the best way to do this?
--
Thanks, HP