Hi,
Take a look at question 7 on the following link -
http://ashishmathur.com/knowledgebaseII.aspx
--
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