Hello,
I have cut in another topic with this question, but probably it is better if I stop being lazy and write my own in the propper forum.
I am thinking about a "dynamic" table showing the names of the customers in C2:IV2(?) and the product clusters in B3:B1000(?)
With a function I would then determine that if the row has no product cluster info (blank cell), then on clumn A there would be an "X". The same way, if in a column there is no customer name (blank cell) then on row 1 there would be an "X".
NOTE: the list of customer names and product clusters would come from another sheet (a sort of a database).
Example:
There are product clusters in B3:B10 and B12:B20. Then A11 and A21:A65536 would be marked "X" (yes, I still have Excel 2003). In this case the correspondent rows would be automatically hidden. I would not want to manually unhide any of them - if I want to see them I would have to go to the database sheet and enter some value in the correspondent slot.
file - http://www.mediafire.com/?84hze1cj9rwm7vu
With this file I would have a dynamic template that would fit all the ranges.
Thanks in advance.
I have cut in another topic with this question, but probably it is better if I stop being lazy and write my own in the propper forum.
I am thinking about a "dynamic" table showing the names of the customers in C2:IV2(?) and the product clusters in B3:B1000(?)
With a function I would then determine that if the row has no product cluster info (blank cell), then on clumn A there would be an "X". The same way, if in a column there is no customer name (blank cell) then on row 1 there would be an "X".
NOTE: the list of customer names and product clusters would come from another sheet (a sort of a database).
Example:
There are product clusters in B3:B10 and B12:B20. Then A11 and A21:A65536 would be marked "X" (yes, I still have Excel 2003). In this case the correspondent rows would be automatically hidden. I would not want to manually unhide any of them - if I want to see them I would have to go to the database sheet and enter some value in the correspondent slot.
file - http://www.mediafire.com/?84hze1cj9rwm7vu
With this file I would have a dynamic template that would fit all the ranges.
Thanks in advance.