Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identifying correct row
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying top scores | Excel Worksheet Functions | |||
Identifying Outliers | Excel Discussion (Misc queries) | |||
Identifying | Excel Discussion (Misc queries) | |||
vba, identifying a range | Excel Worksheet Functions | |||
Identifying links | Excel Discussion (Misc queries) |