Total Novice Needs Help

**Onlyblue** · 06-15-2012, 12:45 PM

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

**kukur99** · 06-15-2012, 01:04 PM

You can use VLOOKUP.
If you could send a small sample, I could help you out on that.

**vandan_tanna** · 06-15-2012, 01:06 PM

Hi Onlyblue:

Please change title of your post. See forum rule #1

Please read and adhere to these simple rules!

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

**royUK** · 06-15-2012, 01:06 PM

The database is basically a table. You can use VLOOKUP across workbooks

**jeffreybrown** · 06-15-2012, 02:03 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.