I'm not exactly sure Iunderstand your arrangement, but I frecuenty have
something I think is similar, where I get information from my Access basted
Sales program, often on different sheets (sales, collections, products,
selease people, etc.). I add a sheet and make some columns directly linked
to cells and others to vlookup. Sometimes I have to use the *1 to convert
numbers from text format, sometimes add a column just for selection process
where I have to combine a product and size like a1&b1, to get unique data.


"Raspberry" wrote:

There has to be an easier way of doing this. I downloaded a text file from
an online source into my Excel 2003 program. The infromation however is
spread across a series of 5-6 worksheets. For example, worksheet one will
tell me the name of the project and give me an ID number and then worksheet 5
will give me the ID number and the contact information. While I would just
sort, copy, paste to have a main worksheet, there are multiple contacts per
project so I've been having to go through and manually match them up to the
proper project. Is there an easier way of doing this?! I was thinking pivot
tables...but I don't think that will work for this. Then I was thinking
queries but as far as I am reading the query only works if the info you
download is in html or some sort of web format or the information is coming
from an external source...but I have all the info now.


Someone, please help!