Shreesurya
Board Regular
- Joined
- Jul 7, 2014
- Messages
- 50
Please help!
I want to search a text from a cell in a column and find out Row # and paste the row number in next sheet and copy paste whole row next to that.
Eg.
<tbody>
</tbody>
Below is the raw data for your reference.
Note: It should split the text from the cell and search, Example: in first cell it says Institution Number - so it should be 3 way search like below. and loop for every cell in A Column and search in both B & C Column.
1. Institution
2. Number
3. Institution Number
<colgroup><col><col><col></colgroup><tbody>
</tbody>
In need of desperate Help.
I want to search a text from a cell in a column and find out Row # and paste the row number in next sheet and copy paste whole row next to that.
Eg.
Text String | Row # | Table info | Table Info | ||
Account | 2 |
<tbody> </tbody> |
<tbody> </tbody> | ||
Account | 3 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Below is the raw data for your reference.
Note: It should split the text from the cell and search, Example: in first cell it says Institution Number - so it should be 3 way search like below. and loop for every cell in A Column and search in both B & C Column.
1. Institution
2. Number
3. Institution Number
EDW Field Description | Copasysfieldname | Field description |
Institution Number | EscrowAccountComputeDate | Date on which escrow account is computed |
Account Number | EscrowAccountStatementDate | date on which escrow statements are sent |
Close Code | EscrowAdvanceBalance | Escrow advance balance amount |
Credit Insurance Payment Amount | EscrowAnalysisDate | Escrow analysis date |
Principal Balance | EscrowAnalysisDisbursmentAmount | Escrow Disbursement amount |
C Info Seg Indr | EscrowAnalysisShortAmount | Shortage amount in escrow analysis |
Escrow Balance | EscrowBalance | Escrow balance amount |
Payoff Penalty Flag | EscrowBorrowerContactDate | Escrow borrower contact data |
Last Activity Date | EscrowCityTaxAmount | Escrow city tax amount |
Last Activity Date Nbr | EscrowCityTaxDate | Escrow city tax date |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
In need of desperate Help.