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