Ok I am not even sure if this is possible...but I am hoping since I thought
of it someone else would have also and made it an option.

Here is what I want to do...I hope you can follow.
On Sheet2 in Column A I would like the information from Sheet1 Column E but
only if Sheet1Column D reads the correct state.
I am trying to tie the worksheets together Sheet1 is the main one. I have
customer names and company names and I would like to connect the worksheets
for each state by Company name. The customer info is on Sheet! but also
mentions the company they work for and on the other Sheets (by state) I would
like to go into more detail about the company....like address and phone #.
I know this would be easier in Access but I am almost finished showing
others just how to use Excel....at this time I do not want to have to start
from scratch.

Let me know if you think you know what I am trying to do and if it can be
done.

--
Thanks!
Mickie

try this in Sheet2 cell A1
=if(Sheet1!D1="correct state",Sheet1!E1,"")

--
If this helps, please remember to click yes.


"Mickie" wrote:

Ok I am not even sure if this is possible...but I am hoping since I thought
of it someone else would have also and made it an option.

Here is what I want to do...I hope you can follow.
On Sheet2 in Column A I would like the information from Sheet1 Column E but
only if Sheet1Column D reads the correct state.
I am trying to tie the worksheets together Sheet1 is the main one. I have
customer names and company names and I would like to connect the worksheets
for each state by Company name. The customer info is on Sheet! but also
mentions the company they work for and on the other Sheets (by state) I would
like to go into more detail about the company....like address and phone #.
I know this would be easier in Access but I am almost finished showing
others just how to use Excel....at this time I do not want to have to start
from scratch.

Let me know if you think you know what I am trying to do and if it can be
done.

--
Thanks!
Mickie