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!

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!

It sounds like your "text" file may in fact be a relational database. If you
have the option, download the file in CSV format and see if that makes a
difference.

I don't think that pivot tables will help you here.

It may be better to try and use Access (which is a relational database
management application) rather than Excel, though it is not as simple to use.

"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!