In the below data my aim is to get information from a specific cell
based on a specific conditions.
In the data sheet you can see tables for different regions say
atlanta and also different product names under them and their shares
in different months
Ex:Suppose i want to know the share% of product 'abilify' for the
month sep 2007 in Atlanta region(which is 19.5% as per below data) or
share% of product 'abilify' for the month sep 2007 in Great Lakes
region(which is 18.4% as per below data).
I am not able to think how to code this in vba as i first have to
locate Atlanta and under it i'll locate abilify and then goto the
column share% in the month of september.
Aug07 Share% Sep07 Share%
Oct07 Share%
Atlanta 2,556,973 100.0% 2,401,393 100.0% 2,396,721 100.0%
Abilify 469,224 18.4% 468,771 19.5% 475,257 19.8%
Geodon 574,200 22.5% 549,197 22.9% 568,479 23.7%
Aug07 Share% Sep07 Share%
Oct07 Share%
Great Lakes 2,556,97 100.0% 2,401,393 100.0% 2,396,721 100.0%
Abilify 469,224 19.4% 468,771 18.4% 475,257
19.9%
Geodon 574,200 22.6% 549,197 22.9% 568,479
24%
Also i was thinking if its possible to use the above data as an input
to collate all data under one table as shown below(this table will
have all regions and products and the monthly share):
Region Product Aug_share% Sep_share% Oct_share%
Atlanta Abilify 18.4% 19.5%
19.8%
Atlanta Geodon 22.5% 22.9%
23.7%
Great Lakes Abilify 19.4% 18.4%
19.9%
Great Lakes Geoden 22.6% 22.9% 24%
Please help.
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
