I want to copy value from one worksheet to another sheet within same workbook for two column.
I want the first or second column to be searchable means dropdown with dynamic suggestion as am typing based upon the value another column must be filled.
Clear understanding purpose:
For example consider a workbook with sheet 1 and 2.
In sheet 2 it has content of
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
In sheet1 when I type in column i need to show suggestion as 11,12,13 when typed 1
After typing as 11 it complete neighbor column as 1760 value
NO Value
11 1760
I want the first or second column to be searchable means dropdown with dynamic suggestion as am typing based upon the value another column must be filled.
Clear understanding purpose:
For example consider a workbook with sheet 1 and 2.
In sheet 2 it has content of
11 | 1760 | 3097600 | 1760 |
12 | 3520 | 6195200 | 1760 |
13 | 5280 | 9292800 | 1760 |
43 | 7040 | 12390400 | 1760 |
5 | 8800 | 15488000 | 1760 |
6 | 10560 | 18585600 | 1760 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
In sheet1 when I type in column i need to show suggestion as 11,12,13 when typed 1
After typing as 11 it complete neighbor column as 1760 value
NO Value
11 1760