LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Arranging rows function wanted

Im having about 100 rows in the A-column where the user can enter names.
The names will be entered randomly; one name can be at A1 the next at A23
and so on.

In column B I want the names from the A column to be arranged without
blank rows starting from B1. It should not matter if there is 80 names in the
A column or 20 names

I want this to be made by a function, it doesnt matter if it will be a long
one. I dont want to use an on action macro.

Thanks!

Tim

 
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
Repeating rows not wanted Opal Excel Worksheet Functions 11 April 8th 10 02:08 PM
Removing rows not wanted... Jambruins Excel Discussion (Misc queries) 15 September 26th 09 04:08 PM
Arranging single-row records across multiple rows Greg Spencer Excel Worksheet Functions 4 October 13th 08 09:20 PM
arranging excel tabs (charts vs worksheets)in multiple rows/dimens ajk2 Charts and Charting in Excel 0 August 24th 05 03:22 PM
MACRO Wanted to compare Rows of 2 Shts. Les Wegg Excel Programming 0 May 11th 05 01:40 PM


All times are GMT +1. The time now is 08:49 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"