[h=2]I want to copy value from one worksheet to another sheet within same workbook for two column.[/h]
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
In sheet1 when I type in column i need to show suggestion as 11,12,13 when typed 1
After chosing as 11 it complete neighbor column as 1760 value automatically
NO Value
11 1760
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
In sheet1 when I type in column i need to show suggestion as 11,12,13 when typed 1
After chosing as 11 it complete neighbor column as 1760 value automatically
NO Value
11 1760
