Filtering with spaces between rows

Closed

diestra123 Posts 10 Registration date Monday October 22, 2012 Status Member Last seen July 15, 2013 - Apr 4, 2013 at 08:05 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Apr 4, 2013 at 10:46 AM

Hi All,
Is there a way I can filter my column if there are spaces between rows? the spaces were put there for neat presentation purposes. :(

thanks in advance for your help.

Filtering with spaces between rows
Twitter spaces on desktop - Guide
Fstab path with spaces - Guide
Dots instead of spaces in word - Guide
Excel vba copy rows to another worksheet based on criteria ✓ - Excel Forum
How to move rows automatically in excel based on cell value ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
Apr 4, 2013 at 10:35 AM

Hi Diestra123,

I don't think Excel has that functionality.
A workaround could be to create double entries, where the text color of the duplicate is turned white. This way it looks like an empty row, but Excel is still able to filter.

Best regards,
Trowa

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
Apr 4, 2013 at 10:46 AM

Here is a code that might be helpfull in creating the above:

Sub CreateDub()
Dim x As Integer
Dim sCol As String
sCol = "H" 'Adjust Column letter to match your data.
x = 2 'Data starts at row 2, if not change the number.
Do
Range(sCol & x).Copy Range(sCol & x + 1)
Range(sCol & x + 1).Font.ColorIndex = 2
x = x + 2
Loop Until Range(sCol & x).Value = vbNullString
End Sub

Similar discussions

Copy row and insert n times

macro for inserting multiple rows between data

Copy and insert rows and number of times

Duplicate rows based on cell value

Copy rows n times in Excel

Similar discussions

Subscribe To Our Newsletter!