Home > IT Answers > Microsoft Windows > Picking values in the intersection of row and column values
Gahlan
5 pts.
 Picking values in the intersection of row and column values
Microsoft Excel, Microsoft Excel macros, VBA, 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

Software/Hardware used:
ASKED: April 23, 2009  4:40 AM
UPDATED: April 23, 2009  12:40 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _