AFAIK, this can't be done ... perhaps with code.

BUT, I don't really see a need for it.
You can reference the contributions by name and time frame relatively
easily.

Say you have each of the names going down Column A, with the monthly
contributions going across the columns, say from "Jan" in Column B to "Dec"
in Column M.

With names in say A2 to A100, and months in *text* form, from B1 to M1,
Enter a name to find in say N1, and in N2 to N4 (you did say 3 months) you
could enter 1 *or* 2 *or* a 3rd month to total.

You could then try a formula something like this:

=SUMPRODUCT((A2:A100=N1)*((B1:M1=N2)+(B1:M1=N3)+(B 1:M1=N4))*B2:M100)

Does this sound like something you could use?

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Johnny Google" wrote in message
ups.com...
RD,

Thanks, but perhaps I wasn't clear with my use of the word 'Label'. I
mean to say I want to create a named cell (i.e. John Smith:January)
such that it can referenced later if the name and month are known. Not
to produce that content in the cell. The content of the cell will be
$500, for example.

Does this make sense? I can try to re-explain if not.

On the January sheet, there will be another column of names and I want
to reference the values for contributions for each member for that
month accurately. So, my hunch is that if I can have the cell
label/name created by reference, and be able to call it by reference, I
can avoid getting incorrect data - down the road.

Thanks,

John


RagDyer wrote:
Try something like this:

=B1&":"&A2
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Johnny Google" wrote in message
ups.com...
What I am trying to do: Create cell labels that are a composite of the
contents of other cells.

Example: An investment club contributions sheet for all months and all
members

A1 = Name
A2 = John Smith
B1 = January
B2 = $500

I want to create a label for cell B2 such that it takes from $A2 and
$B$1 so that the label is something like "January:John Smith" .... or
something similar....

Why?

Because I will create a seperate sheet for each month where I can
reference this master sheet and show the current month (and perhaps the
previous 3 months) contributions for each member.

I can currently do this by just referencing by reference (position)...
but I want to make this a little smarter so that when members are added
or deleted from the master, all monthly sheets will always be correct
because they are referencing a smartly labeled cell.

So... how to create the labels dynamically - and how to reference them
dynamically in the monthly report sheets.

Thanks,

John