Thanks for your reply McGimpsey.. My next task is Access apparently.. I think
I might send your reply to my boss.. because I don't think it makes a very
good database either. Hence why I have struggled with it.. setting myself up
for disaster sounds about right too.. lol..

"JE McGimpsey" wrote:

The first thing you need to know is that Excel is not a database
application, and while it is commonly used for databases, it doesn't do
them well. Expecting a database developed in XL to be "complete idiot
proof" is setting yourself up for disaster.

Without knowing anything about your data or your reporting needs, the
only thing I could tell you is that, in general, you should use rows for
records and columns for fields within recocords.

In article ,
MadMoose wrote:

I need to learn all about Excel and how to make a database.. I have read
and read and done practise tutorials but I just cannot grasp the concept, it
completely goes over my head everytime. I am quick to learn when I am being
shown or told exactly what to do, can anyone help me learn all about Excel.. ?