Sir Babydum GBE
09-13-2005, 03:50 AM
Hi, I need some urgent help, as I need to finish this project today cos i'm going on my vacation tomorrow - purleeeze! : pray2:
Range G9:AD483 has some blank cells and other cells where the text will always end in "group " and then a number (e.g. "Group 1")
C1 will contain the group I am currently examining - and will simply say "group 1" (or whatever number).
I want to run a macro that will look at what I've put in C1, and then will hide all rows in range from 9 to 483, Except rows where cells in the range G9:AD483 contain text that end with whatever group is mentioned in C1.
So for example:
Cell F28 contains "Mathematics Class A, Group 1"
Cell G29 contains "Mathematics Class A, Group 2"
And my key cell, C1, contains "group 1"
So the macro will hide row 29, but will leave row 28 alone.
Can someone help please?
Range G9:AD483 has some blank cells and other cells where the text will always end in "group " and then a number (e.g. "Group 1")
C1 will contain the group I am currently examining - and will simply say "group 1" (or whatever number).
I want to run a macro that will look at what I've put in C1, and then will hide all rows in range from 9 to 483, Except rows where cells in the range G9:AD483 contain text that end with whatever group is mentioned in C1.
So for example:
Cell F28 contains "Mathematics Class A, Group 1"
Cell G29 contains "Mathematics Class A, Group 2"
And my key cell, C1, contains "group 1"
So the macro will hide row 29, but will leave row 28 alone.
Can someone help please?