Thread
:
Identifying correct row
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Identifying correct row
For a formula look in the help index for MATCH
for a macro look in the vba help index for FIND
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"RCulli0322" wrote in message
...
Am a novice XL user. Trying to learn how to access row data based on a
specific text string in (possibly) different columns, i.e., if "Current
Assets" is in C5, and I want to manipulate data in cols 10 thru 20 on the
same row, and want to have the same formula access "Current Assets" data
in
another worksheet which may be on row 6 with its corresponding data fields
in
cols 10-20. Basically, trying to identify the line that "Current Assets"
is
on, and then use that knowledge to work with the numerical data related to
that acct.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett