On Tue, 28 Oct 2008 06:48:01 -0700, DaveKid
wrote:

Hi Ron, What data would you like me to provide you with?

"Ron Rosenfeld" wrote:

On Mon, 27 Oct 2008 09:12:06 -0700, DaveKid
wrote:

Is there any way I can avoid this duplication of data? Can i not just ask
excel to look in these 3 cells and return the result instead of having to
concatenate another column?

Yes, you can. But you don't provide enough data to say more than that.
--ron


Not knowing what you are trying to accomplish makes advice very difficult.

You certainly haven't mentioned why you have to concatenate data.

You mention you are trying to get data on your "front sheet" but that your data
is on some other sheet.

The same techniques that allow you to put data on FrontSheet that is posted on
DataSheet should allow you to look at particular cells on DataSheet.

For example, to show on FrontSheet the SUM of column B on DataSheet, you could
use a formula of the type =sum(datasheet!B:B)

The same is true for other functions.

Pivot Tables can also be useful in presenting data in an organized fashion.
--ron