Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Copy rows of data (eliminating blank rows) from fixed layout

Worksheet 1 with fixed layout but random #s of rows for each category:

CategoryFruit:
Apple 1
<blank row
<blank row
Orange 2
<blank row

CategoryDrink:
Milk 3
<blank row
Soda 4
<blank row

Desired result on another worksheet with no blank rows:

Apple 1 CategoryFruit
Orange 2 CategoryFruit
Milk 3 CategoryDrink
Soda 4 CategoryDrink

Hope this makes sense. Please help!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Copy rows of data (eliminating blank rows) from fixed layout

Something to add:

Second worksheet will be populated automatically when the data in sheet 1 is
updated.

Thank you.

"Sweepea" wrote:

Worksheet 1 with fixed layout but random #s of rows for each category:

CategoryFruit:
Apple 1
<blank row
<blank row
Orange 2
<blank row

CategoryDrink:
Milk 3
<blank row
Soda 4
<blank row

Desired result on another worksheet with no blank rows:

Apple 1 CategoryFruit
Orange 2 CategoryFruit
Milk 3 CategoryDrink
Soda 4 CategoryDrink

Hope this makes sense. Please help!

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
Eliminating Blank Rows Tatebana Excel Discussion (Misc queries) 4 February 19th 07 06:24 PM
Merge data rows at fixed ratio AirBoss Excel Discussion (Misc queries) 13 December 19th 06 04:23 PM
Get number of rows that data uses, including blank rows Denham Coote Excel Discussion (Misc queries) 5 August 22nd 06 02:10 PM
Get number of rows that data takes up, including blank rows Denham Coote Excel Worksheet Functions 2 August 21st 06 09:18 AM
Copy rows of data to another worksheet where ReturnDate is blank Helen McClaine Excel Discussion (Misc queries) 2 March 28th 05 11:33 PM


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