Hi - I'm new to Macros/VBA, but I need to get my data to automatically outline, by finding all blank cells and grouping them under the non blank above - i.e.
A1 Claire
A2 (blank)
A3 (blank)
A4 (blank)
A5 Andrew
A6 (blank)
A7 (blank)
A8 (blank)
I would like A2:A4 to be grouped together under A1, and A6:A8 to be grouped under A5
Any suggestions would be very useful - annotations in the code would be extremely helpful also so I can understand what each part is doing
Many thanks
claire
Hi Claire,
Welcome to the forum
You could just use a sort command.
The code below will take the data in the A column and arrange it to have the blanks below the non blanks.
Of course this is code to work on your simplified example, but can be extended for larger blocks of data.
Please Login or Register to view this content.
Regards,
Rudi
Actually I misunderstood you.
I'll work on a macro to "outline"the blanks ....
Here is the new macro.
Please note it is designed ONLY to work with blanks between the cells with values in them.
Please Login or Register to view this content.
Last edited by RudiS; 04-15-2014 at 03:17 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks