Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Camalla
 
Posts: n/a
Default 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.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Items in a List jcliquidtension Excel Discussion (Misc queries) 1 April 5th 05 10:23 PM
Link to password protected workbook dunnotar02 Excel Discussion (Misc queries) 1 March 22nd 05 06:44 PM
how can i link sheets in my excel workbook new secretary Excel Worksheet Functions 1 December 31st 04 10:08 PM
How do I find out what items are in one list but not in another l. Michelle Craig Excel Discussion (Misc queries) 2 December 22nd 04 08:32 PM
How do I link sorted data to other workbook sheets? Cori Excel Worksheet Functions 1 December 10th 04 05:00 PM


All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"