#1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Empty rows

Did you try my shot at this in the other branch ? Thought it returned results
similar to what you're re-describing below.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GARY" wrote:
Ideally, after moving the data in A1's related cells, all of A1's
related cells should be in row 1.
Ideally, after moving the data in A7's related cells, all of A7's
related cells should be in row 7.

I do NOT want to clear the cells in rows 2 thru 6.
I want to find cells on these rows that contain data (so I can move
these cells, too).

Gary

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
How to find next value if rows between are empty? joes Excel Discussion (Misc queries) 2 June 16th 06 04:26 PM
Deleting All Empty Rows bodhisatvaofboogie Excel Discussion (Misc queries) 3 May 18th 06 12:36 PM
Delete empty rows with cell type 2 FrankNL Excel Discussion (Misc queries) 1 May 3rd 06 11:10 AM
[excel 2003] Delete empty rows RedCell Excel Worksheet Functions 1 February 21st 06 11:18 AM
Pivot Tables: How do I show ALL field rows, including empty rows?? [email protected] Excel Worksheet Functions 2 April 8th 05 06:21 PM


All times are GMT +1. The time now is 04:48 PM.

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"