Hi Guys,
I have this data in which Column A is category and Colomn B is the no. of Square cells to shade, the color for shading is defined by the corresponding color of category in column A. Right now, i am doing this manually, but the data i have to do this is getting out of hand. So, i will like to automate this with a macro, which will start with category in cell A2, read the no. of squares to shade in cell B2 and then go to cell G5 and shades the cells with the color, then go next category and do the same.
I am attaching a dummy worksheet to show what i am doing, i have filled the example manually just to be clear.
I really need to do some sort of macro for this. Any help will be really appreciated.
Thanks.
Roop
Bookmarks