LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Add blank columns to long list of data - Excel 2007

Your subject reads add blank columns.

Your description reads blank row.

Which do you want and what are the 3 criteria?

From your description I'm not clear on your layout.

VBA is required to add a blank row or column.


Gord Dibben MS Excel MVP

On Wed, 9 Sep 2009 12:44:36 -0700, LisaK
wrote:

is it possible to auto add a blank row based on criteria in 3 adjacent
columns? the data is sorted based on these 3 columns, but we don't need
subtotals, just blank rows. Thank you.


 
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
Getting to first blank row from middle of long list? MS Questionnairess Excel Discussion (Misc queries) 7 July 9th 07 08:52 AM
Excel thinks blank columns have data? Mark Brown Excel Discussion (Misc queries) 1 May 17th 07 02:33 PM
Retrieve multiple data rows data from a very long list and copy t mathew Excel Discussion (Misc queries) 1 September 13th 06 08:24 PM
How do I print a long vertical list in two columns in 1 page ? rosendo Excel Discussion (Misc queries) 1 May 21st 06 05:39 AM
How do I add grid lines to a LONG list with 3 columns? Eclectic Creations & Collectibles New Users to Excel 5 January 9th 06 01:33 PM


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