Grouping columns based on a value in a cell

[msudbb]

Hi

This may be a simple piece of code, but I am new to VBA so any help will be greatly appreciated!

I have one row, which every 6th cell (e.g. F1) either contains the word "Group" or "Don't Group" based on an if statement about the contents of the previous 5 cells (e.g. cells A1:E1).

e.g. if all cells A1:E1 say "yes", then F1 says "Group". Otherwise, it says "Don't Group".

This group of 6 cells is repeated along the row multiple times (up until cell FF1).

What I want is a macro that will go along this row, and every time it sees the word "Group", will group together the 5 previous columns (the ones which say "yes") only leaving the one which says "Group" visible.

I want to group the columns as opposed to hide them as it may be necessary for someone to come along later and review the file, therefore i want to make it easy to view the columns which will not be visible.


Thanks for your help
Rob

[royUK]

If you placed the data in rows instead of columns you could use AutoFilter.

[msudbb]

thanks roy

unfortunately i can't do that.

Each of the first 5 columns represents a day of the working week.

Under each day there are more data entries than there are columns wide in an excel sheet
i.e. if i transpose my table, it simply won't fit!

Rob

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[msudbb]

thank you thank you thank you both,

it works a treat, and has made my life a lot easier!