how do i link a list of items in a workbook to worksheets in the .
 

how do i link a list of items in a workbook to worksheets in the same
workbook and also link the format? I able to accopmplish each individually
but not both.

Formulas return values--not formatting.

How did you get the link to formats to work?

---
Sometimes, you can use a macro to do the work for you.

Camalla wrote:

how do i link a list of items in a workbook to worksheets in the same
workbook and also link the format? I able to accopmplish each individually
but not both.

--

Dave Peterson

Camalla

No way to link Formats unless you are using Conditional Formatting.

BTW, how are you able to link Formats currently?

The data linking I can see, but not the Formats.


Gord Dibben Excel MVP

On Fri, 22 Apr 2005 10:35:02 -0700, "Camalla"
wrote:

how do i link a list of items in a workbook to worksheets in the same
workbook and also link the format? I able to accopmplish each individually
but not both.