In your main sheet you can introduce a formula using COUNTIF to give a
unique sequential count for each of your Visa numbers. Supposing they
were listed in column A, then you could have a formula like this:

=IF(A2="","-",A2&"_"&COUNTIF(A$2:A2,A2))

Then copy this down as far as you like.

Then in your other sheets you can have an INDEX/MATCH formula to bring
across only the entries that relate to a particular Visa number, and
to do so on sequential rows.

If you post some more details of what you have and what you want to
bring into the individual sheets, then I could add some more details
to my response to you.

Hope this helps.

Pete

On Jan 19, 11:26*pm, hp wrote:
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