I should probably preface this with the fact that I'm a total rookie... I
just happen to accidentally figure out how to do stuff sometimes, and know
"in theory" that some other things *should* work - and well - I need help!

I have a workbook that I use to help patients track their lab returns on.
These patients typically have lab work done every 3 months for a period of
time, easing back to every 6 months, then annually for life. We encourage
patients to be proactive and track their data in an Excel spreadsheet.

So I've got this great spreadsheet all ready to go. The problem? Patients
oftentimes want to keep more data than the doctor wants to see when reviewing
labs. (I.e., perhaps they keep an eye on another health concern, that sort
of thing - not pertaining to our particular focus.) So I've got an expanded
spreadsheet where the patient can put in whatever the heck they want to put
in - it's long! Then I've got a summary spreadsheet for the doctor with just
the specific info he wants to see.

What I've done to start with is link the cell value from one cell on the
expanded worksheet to the summary worksheet (i.e., copy first cell, paste
special, paste link into the receiving cell). It works great! I love it!
(Well, except the fact that I'd like it to be kind of automatic and I don't
like the "0" that show up in fields that may not have been run for some odd
reason or another. (I.e., not every lab test is run every round of labs.)

Oh - and I should probably say that I've got conditional formatting in both
worksheets to make lower than normal reference range values to show as red,
and higher than reference range values as blue.

So here's where it gets interesting. What we've done in the past is copy
the column and paste in a new column for the next round of labs. It has been
the most practical approach up until now... Some patients are a few months
into this regimen, others are nearing 10 years of this regimen. In *theory*
one would think there would be a way to copy that column in the expanded
worksheet into the next column over, do the same in the summary worksheet,
and have the values link up. But no...

Does anyone have any great ideas on how to make this user friendly? Some of
my people are barely able to figure out how to respond to email, much less
manipulate an Excel spreadsheet (which means that I sometimes end up handling
LOTS of entry for patients who are not up to speed quite yet). I need
something that works easily for both them and me!

Thanks for *any* ideas!

Blessings,

dina