Thanks Roger, I appreciate your remarks. It gets lonesome sometimes
supporting our position, but I believe it in my heart to be best. And, as a
matter of fact, I even used your "Custom Views" suggestion for the client I
was working with Friday.....he's not really in to VBA and it solved the
problem for him perfectly.

Vaya con Dios, my friend,
Chuck, CABGx3




"Roger Govier" roger@technology4unospamdotcodotuk wrote in message
...
Hi Chuck

Good to see you also.
.........it seems like every day I learn something new in Excel.......
I don't think any of us will ever stop learning.
Such a rich range of features (as well as annoyances!!).
Like you, I have many clients who know Excel reasonably well, and want to
stick with that rather than go the Access route. I agree with you
entirely,
that even though it may not be the most efficient tool in some
circumstances, as long as one achieves what the client wants, and feels
comfortable in using, that is the acid test.
--
Regards
Roger Govier

"CLR" wrote in message
...
Hi Roger...........
Good to see you, and thanks for the compliment. Thanks also for
suggesting
the Custom Views feature to the OP. I've never used it personally, but
from
your description it should serve the OP well in this instance.
Something
else for me to play with.........it seems like every day I learn
something
new in Excel.......

Vaya con Dios,
Chuck, CABGx3





"Roger Govier" wrote:

Hi Jo

in addition to the excellent advice Chuck has given you, you can hide
columns, rows etc without using VBA (Visual Basic for Applications) if
you
wish by using
ViewsCustom Views.

Select the columns you wish to see, by hiding the ones that are not
relevant
for that particular purpose, then select ViewsCustom ViewsAddgive it
a
meaningful name.
Unhide all the columns and do the same thing, but call that Normal or
Full.
You can create as many views as you wish in this manner, and select
them
at
will.

To make selection easier, add Custom Views to your toolbar.
ViewToolbarsCustomisechoose View in the left hand panedrag Custom
View
from the right hand panedrop in somewhere on your toolbar
(Note it must be somewhere before the final dropdown at the end of the
toolbar)

Now, you will have the different views available as a dropdown at all
times.

If you also mark the top row (header row) of your sheet, and choose
DataFilterAutofilter, you will find that you can easily filter your
data
within any view, to show only the rows that you wish.

--

Regards
Roger Govier

"Jo4321" wrote in message
...
Awesome CLR. That would work for us, I think, if I could combine the
info
into one spreadsheet but still have the data easy to view. I
didn't
know
that there was a way to view unweildy spreadsheets to "hide" some of
the
columns

Now, so I can look up tutorials on how to do this, what would that
process
be called? (making buttons that have some kind of code to hide the
columns)

Also, what does the acronym VBA mean that you mentioned a few times.

Thank you.
Jo

"CLR" wrote:

Personally, I would combine as many of the different spreadsheets as
I
could
into one master file. You have over 250 columns and 65000 rows to
play
with.
Viewing is no problem if taken into the design. For instance, you

can
have
a main menu that would have buttons for various categories of
information,
such as "Personal", "SkillSet", or whatever your various different
files
now
separate, and when each button is pressed, only the columns for that
category
are visible, the rest are hidden.......or the whole thing can be
viewed
at
once if desired. As for Reporting, or Analysis, specific columns
and
or
rows
can be pulled out of this database and moved to a "working" sheet
for
processing and formatting that does not affect the database. If you
must
deal with information in multiple Excel files, it is doable with
VBA.....each
file can be opened from the master file, when needed, Edited, or
information
extracted, and then the file closed, all under program (VBA)
control.
Virtually anything you can imagine doing by manual means, can be
automated
with VBA and Excel can do at the push of a button.

I have written small programs in Excel whereby the user gets a
downloaded
file from the company computers. They open my program, retrieve the
downloaded file, and extract data from it, format the data for
presentation,
run calculations and other analysis on the data, and even email
portions
of
it to others. The downloaded file can be in the form of an Excel
file, a
text file, a .pdf, or it could be the result of a MSQuery of and
external
database from Access, Excel, or other database programs.......the
possibilities are endless. It does not matter if Excel is THE most
efficient
program to do all the things one might want to do in, but that it
CAN
do
those things and the user is comfortable with it, so thereby will
use
it.
The pureists will argue that point, but who cares? No matter how
nice
a
program is or how efficient, if the user is uncomfortable with it,
they
won't
use it.