Thread: Sub to write another result dimension into comments over formula c
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Sub to write another result dimension into comments over formula c
Here's my set-up (book is set to manual calc)

In sheet: Y, in A1:B5, I have data

Area Brch
Zone1 Br10
Zone2 Br11
Zone1 Br12
Zone2 Br13

and in sheet: X, in A1:B3

Area Brch
Zone1 2
Zone2 2

Unique zones are listed in A2 down
In B2, copied down is the formula: =COUNTIF(Y!A:A,A2)

I'm looking for a sub which can auto-write the names of the 2 branches into
the comments over the formula cells B2:B3 (which return the counts of the #
of branches for the zones) when I press F9 to recalc the book. This is to
provide another result dimension to the table in X, so as to speak.

So in the comment for B2 will be:
Br10
Br12

and in the comment for B3 will be:
Br11
Br13

Appreciate insights on how the above could be achieved. Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote