I maintain a large document that I use for multiple purpose - how do I manage
this document to do the task without having to re-type certain of the same
info I need?

Cynthia

You are so short on details that I fear no help will be forthcoming.

The only thing we know for sure is you have a large document.

Is your document an Excel Workbook?

Please re-post.


Gord Dibben MS Excel MVP

On Thu, 24 Aug 2006 08:28:01 -0700, Cynthia
wrote:

I maintain a large document that I use for multiple purpose - how do I manage
this document to do the task without having to re-type certain of the same
info I need?

I maintain a large document in excel as a spreadsheet consising of firm name,
partner name, address, email address, telephone #, fax # date of application
and other data. I also use this same data to track invoices which means I
only need name of partner and firm address in a separate worksheet - how do I
manage this document to do the task without having to re-type certain of the
same info I need?


"Gord Dibben" wrote:

Cynthia

You are so short on details that I fear no help will be forthcoming.

The only thing we know for sure is you have a large document.

Is your document an Excel Workbook?

Please re-post.


Gord Dibben MS Excel MVP

On Thu, 24 Aug 2006 08:28:01 -0700, Cynthia
wrote:

I maintain a large document that I use for multiple purpose - how do I manage
this document to do the task without having to re-type certain of the same
info I need?

Sounds like VLOOKUP function may do the job.

See Debra Dalgleish's site for excellent assistance with VLOOKUP and a download
example workbook.

http://www.contextures.on.ca/xlFunctions02.html

And for drop-down Data Validation lists that allow selection options.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP


On Thu, 24 Aug 2006 10:20:02 -0700, Cynthia
wrote:

I maintain a large document in excel as a spreadsheet consising of firm name,
partner name, address, email address, telephone #, fax # date of application
and other data. I also use this same data to track invoices which means I
only need name of partner and firm address in a separate worksheet - how do I
manage this document to do the task without having to re-type certain of the
same info I need?


"Gord Dibben" wrote:

Cynthia

You are so short on details that I fear no help will be forthcoming.

The only thing we know for sure is you have a large document.

Is your document an Excel Workbook?

Please re-post.


Gord Dibben MS Excel MVP

On Thu, 24 Aug 2006 08:28:01 -0700, Cynthia
wrote:

I maintain a large document that I use for multiple purpose - how do I manage
this document to do the task without having to re-type certain of the same
info I need?