Stew
The layout of your data is not clear at all. You say you have "Daily
Single Columns". That implies that each column is for a different date.
But then you say that each ROW has a piece of information about "that days
activity" and you say c3 has this, d3 has that and e3 has something. That
implies that each row is for a different day. Describe the layout of what
you have. That is, this column has that, that column has this other, and so
forth. Then do the same for the rows. Then do the same for the final
product you want. HTH Otto
"stew" wrote in message
...
Hi all

Another little bit for me to Learn.
I have a date Sheet arranged in Daily Single Columns. each row has a piece
of information about that days activity. ie c3 = USA, d3 = USA,e3 =
canada.

on a seperate work sheet i only want to pick out the USA entries and not
the
canadian entries with the basis of the following
=IF(INDIRECT("'Date
Details'!"&ADDRESS(3,(INT(ROW()/7-53)+3)))="usa",(?),(?)

How can i Get the sperate worksheet only the details of THE usa Columms

This has to appear in a List Format .ie

12/3/2008 HOTEL usa
lINE oNE ADDRES
Line 2 Address
ETC

Thanks For Looking

Stew

How can i Get the sperate worksheet only the details of THE usa Columms