Senin, 13 Februari 2012

[ExcelVBA] Ho to filter both columns and rows

 

Hi
Pls help me providing the formula or macro for the below requirement
ex:
  A B C
X 1 4 7
Y 2 5 8
Z 3 6 9

1) When the user selects 'A' and 'X' the output should be 1
2) Output should display in another cell
 
The user will not be able to see the table he just enters 'B' and 'Z' and output should display automatically in new cell '6'

Thanks in Advance!
Vimal

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___

Tidak ada komentar:

Posting Komentar