Picking values in the intersection of row and column values
Home > IT Answers > Microsoft Windows > Picking values in the intersection of row and...
Gahlan
5 pts.
0
Q:
Picking values in the intersection of row and column values
Microsoft Excel, VBA, Microsoft Excel macros, Visual Basic for Applications
In row 1(column 2-column11) i have location"<NAMES>"(all different) and in cloumn1 i have customer codes, and the values at an intersection of particular customer code & location are hard coded.
I m giving the picking values for customer codes and locations from user defined data.
The problem is how to get the Values lying in the cells at intersection of those customer codes and locations.These values then will be returned in one row.

Thanks in advance for giving me the logic to sove this problem
ASKED: Apr 23 2009  4:40 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Gahlan
5 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Apr 23 2009  4:40 AM GMT by Gahlan   5 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Topics about Microsoft » Picking values in the intersection of row and column values   0 pts.  |   Apr 23 2009  8:13AM GMT

[...] FreeThinker’s Web placed an interesting blog post on Picking values in the intersection of row and column valuesHere’s a brief overviewNew Question Created… [...]

 
0