Although it may look like things are strewn "all over the place", they may
actually "be" all in Column A..........check it out, and if so, the Data
TextToColumns feature may help you organize things.

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
I have expenses that when imported from the web, come into Excel all over
the
place, random columns, cells and rows.

I have combined all our departments onto their own worksheets within a
single Excel file, but now I have to pull this all together, and there's
no
rhyme or reason as to how the data is pulled in.

How would I organize this data? I leaning towards Vlookup, but not able
to
get anything to work. Any guidance from the guru's is greatly
appreciated!!!
--
JCarter
Still Learning