Hi all,

I have what I'm sure you will think is a very simple question. I've never used excel for anything more than making tables.

I've joined a new company which uses excel to maintain a customer 'database', on each line it has, customer number, company, contact person, telephone etc etc, with each one in a different box. The customer list is very long and it is saved as its own file.

They keep a record of what each customer spends in another excel file. At the moment they have a print out of the customers and EVERY field is inputted manually into the new excel files which are created daily.

Is there a way to input any one of the pieces of info (name or contact etc) into the spending sheet and then the remainder of the line to be filed in by reading from the customer 'database' file?

Many thanks in advance,

Alan