Help with Microsoft excel spreadsheets

Lifeisbutadream

espresso wrote: »

You misunderstand.

Copy your present list into a new sheet Contact List.xls and then you would only then have to update one worksheet.

Sorry - you need to have a contact list in each worksheet. I cant put everything into the same worksheet because each worksheet contains loads of pages and are filed appropriately (e.g. - September invoices, September Quotes, September visits - they may have 30 pages in each worksheet)

I need to know how to set it up so that I can only have one contact list.

Lifeisbutadream

scottishlass wrote: »

If you had a central contacts list would you then just want to select the customer from a drop down list on a particular spread sheet?

It doesnt work as I currently have it set up - thats what I need to know.

It only works if there is a contact list on each spreadsheet.

scottishlass

Sorry I read it as being all in one work book - so you basically want to link the different excel files.

Lifeisbutadream

scottishlass wrote: »

Sorry I read it as being all in one work book - so you basically want to link the different excel files.

Yes - what I really want is to be able to just update one list every time. I definately cant put everything else into one file - it would be more confusing than it is now..

espresso

Lifeisbutadream wrote: »

Sorry - you need to have a contact list in each worksheet. I cant put everything into the same worksheet because each worksheet contains loads of pages and are filed appropriately (e.g. - September invoices, September Quotes, September visits - they may have 30 pages in each worksheet)

I need to know how to set it up so that I can only have one contact list.

Not true!

I suggest that you read Chippy's post #2 again because it definitely does work!

:rolleyes:

scottishlass

Or if you want to keep the set up with a contacts page in each spreadsheet but linked to the main page you could just link the spreadsheets '=[test1.xls]Sheet1!$A$1'

espresso

Lifeisbutadream wrote: »

Yes - what I really want is to be able to just update one list every time. I definately cant put everything else into one file - it would be more confusing than it is now..

Is is logical to only have one contact list to maintain and it does work using VLOOKUP.

Lifeisbutadream

espresso wrote: »

Not true!

I suggest that you read Chippy's post #2 again because it definitely does work!

:rolleyes:

I read it and I tried it and couldnt get it to work - I said in the post earlier that I must be doing something wrong, but it didnt work . Also though I need it to be a drop-down rather than typing the name in, as without looking through the contacts list I wouldnt know how the name was entered.

Lifeisbutadream

scottishlass wrote: »

Or if you want to keep the set up with a contacts page in each spreadsheet but linked to the main page you could just link the spreadsheets '=[test1.xls]Sheet1!$A$1'

How do you mean?

espresso

Lifeisbutadream wrote: »

I read it and I tried it and couldnt get it to work - I said in the post earlier that I must be doing something wrong, but it didnt work . Also though I need it to be a drop-down rather than typing the name in, as without looking through the contacts list I wouldnt know how the name was entered.

The problem is that only you know exactly what you are trying to achieve. When creating spreadsheets, ease of use and maintainability need to be considered or you will simply make extra work for yourself. It definitely makes sense to only have one contact list to maintain and the quicker you sort it out the better. Did you create a named list called Contacts when you created the Contact List.xls sheet?