Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
JP JP is offline
external usenet poster
 
Posts: 103
Default Dynamic Comments without Gaps in between

hello all,

I have a 1 page summary for 1000 items. At any one time you are looking at
information on 1 of these items. Up to four comments apply to any of these
items. What I would like to do is list the comments so that only the ones
that apply are listed and there are no gaps in between.

Also, there are certain portions of the one page summary that will need a
footnote if a specific one of the comments is applicable and shown below.
Ideally, there is a way to list the comments in order 1,2,3 even if it is
comment 1 comment 3 and comment 4 and make the footnotes on the one page
summary consistent with how the comments are labled.

Any ideas would be helpful. I figured a workable way to make sure there are
no gaps between the comments, however, not how to footnote the applicable
parts of the page.

Regards,

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
Transpose Column With Gaps to Column With no gaps Vincent Excel Discussion (Misc queries) 9 October 1st 07 01:50 PM
Gaps In Bin Locations Tiziano Excel Worksheet Functions 4 August 22nd 06 02:48 AM
Any way to link comments (dynamic) to another cell's contents? KR Excel Discussion (Misc queries) 1 June 27th 06 05:06 PM
repost: plz help- dynamic range with gaps? KR Excel Discussion (Misc queries) 2 August 29th 05 08:57 PM
Transpose Column With Gaps to Row With No Gaps? SteveC Excel Discussion (Misc queries) 5 June 18th 05 01:01 AM


All times are GMT +1. The time now is 07:51 AM.

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"