LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default How do i order selections contigously

On one sheet I have a long list of items which I need my users to scroll down
and, when needed, fill in a value next to the appropriate item in the list.

Most of the list items will not need anything inputting against them.

Then on a different sheet I need a nice tidy summary list which only shows
those list items which have an input against them.

The bit I cant do is getting these few items to display (on a separate
sheet) in a nice neat all together, contiguous way - ie with no gaps

any ideas?

 
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
copy cells down a column (in order) to across a row (same order?? Tampa9 Excel Discussion (Misc queries) 1 December 4th 08 04:23 PM
How stop Excel file UK date order changing to US order in m.merge Roger Aldridge Excel Discussion (Misc queries) 1 October 9th 07 11:52 PM
Series order conflicts with line order Cowtoon Charts and Charting in Excel 3 January 15th 06 08:43 PM
I want a purchase order that includes page number (if to be order. Angela New Users to Excel 1 December 3rd 04 04:39 PM
Daily Macro to Download Data, Order and paste in order Iarla Excel Worksheet Functions 1 November 17th 04 01:59 PM


All times are GMT +1. The time now is 01:08 AM.

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

About Us

"It's about Microsoft Excel"