Search results

What is the macro to color cells inside multiple sheets (eg. Sheet 1 and 2)? Not all cells need to be colored. Only certain range of cells in both sheets. For example, only cells with value 1 and 0 in certain area are to be colored with "red" and "green" respectively. Thank you in advance :)

@SirJB7 Is the file a sort of template? Sorry for asking, but how do you utilize that file? @kchiba Sorry, the updated macro still doesn't return the outcome the example is trying to get. It doesn't filter the table in "Sheet 1" into a 2-columned outcome in "Sheet 2" :(

@Faseeh Sorry, in other words? @kchiba I tested the given macro, it doesn't exactly give me the desired outcome as in the case. It shows me this: A C A J B J B J C J I need an outcome with only one type of activity (eg. activity A) and filter out others, like the following ...

Need help with macro.. A J C S V M - - - - - - - A 2 0 0 0 0 A 0 0 7 0 0 B 0 3 0 0 0 B 0 0 0 5 0 C 0 0 0 0 7 Above is a simple table in Sheet 1. The first column 'A' shows activity A, B, and C. The other columns show names of people involve in one...

Thank you for your time and response :)

sorry for my last post, I managed to solve that. Thanks. The code is, just as an example: 'Range("P1").Range("P6")' Please can you teach me how to hide a column, if the sum of all cells in that column equal to value 0? Thanks in advance.

kchiba, your macro code works perfectly. I notice, it works only when you enter "Hide" on a single specific cell. How about if you enter on any cell on that particular column?

kchiba, what does the 3rd line from the top mean?

Thank you. I will give it a try.

Hi, I'm new to this forum. Any idea about macro that can hide a few columns, based on certain criteria on those columns? I have already posted similar question at Ozgrid forum: http://www.ozgrid.com/forum/showthread.php?t=163079&p=598550#post598550 Many thanks.