Trudy: Check your private messages at excelforum.com
************
Anne Troy
www.OfficeArticles.com

"lburg801" wrote in
message ...

Anne,
I know I read somewhere this past week, a comment made by someone
responding to another post, that creating many worksheets was
unnecessary since the reasons most users stated for doing so could be
accomplished by writing macros to do each job, with less work and fewer
problems. I am so green! I am taking this on in an emergency situation -
the church secrectary died - and she is the only one who knew anything
about what she did or how she did it. The data that I am working with
is basically what one would find in an extensive address book, with a
few more columns pertinent to church activities. There is a separate
financial database. One of the reasons I tried to create a second
worksheet was because there are couples with different last names which
creates a problem in printing labels when a couple shares the same
surname. The following is one of the suggestions to deal with that
problem, but I ran into a lot of trouble trying to copy it to other
cells. Rather than being read as a formula, it became the text inside
the cells. I do not know how to write a formula AND APPLY IT. It seems
there should be a way to apply a fomula to an entire column and have it
automatically covert the cell numbers to those of each row. Is there?
Thanks, Trudy
You could use a 'helper' column to sort by... for example
A:First_Name1, B:Last_Name1, C:AND, D:First_Name2, E:Last_Name2,
F:SORT

F:=if(isblank(B1),E1,B1) and copy it down the column. This will
put
Last_Name1 in F if it exists and Last_Name2 if it does not.
Note: the = sign needs to be at the beggining of the formula

I think this is the easiest way that you won't have to rework the
whole
spreadsheet...again.

Anne Troy Wrote:
My guess is that you're unnecessarily linking. Why do you need the same
information in multiple workbooks?
************
Anne Troy
www.OfficeArticles.com

"lburg801"
wrote in
message ...

The concept sounded simple. Copy the cells from the main worksheet
and
past it as a link in another. What I thought this meant was that any
changes made in the original worksheet would automatically be made
in
the linked worksheet. Consider the database I am using as basically
an
extensive address books with all sorts of information - some missing
when original entries are made and added later, other existing
entries
changed, and finally additions to the database (new rows)

The only changes that were quickly obvious in the linked worksheet
were
rows of #ref! in cells that were linked to rows that had been deleted
in
the original, and a cursory look showed that changes had not been
made
or additions added in the linked data ---- so clearly I don't get
it.
Can you help?

Thanks,
Trudy


--
lburg801

------------------------------------------------------------------------
lburg801's Profile:
http://www.excelforum.com/member.php...o&userid=28338
View this thread:
http://www.excelforum.com/showthread...hreadid=480391



--
lburg801
------------------------------------------------------------------------
lburg801's Profile:
http://www.excelforum.com/member.php...o&userid=28338
View this thread: http://www.excelforum.com/showthread...hreadid=480391