I am new to excel coding...
my question is in excel sheet i have two tabs "field order" one tab and second tab is "master list". in filed order 2 columns that is SIZE,TYPE. In master list 2 columns that is SIZE,TYPE. in master list sheet data is there in SIZE column 2x4,2x5,2x4x7,2x7x8..... if i goto field order sheet in SIZE column i enter "2x4" it comes from masterlist sheet automatically and it worked like predictive.
predictive means if i enter 2x4 it shows like 2x4 if i enter 2x4x then remaining digit 7 will comes automatically from master list.
Thank & Regards
u r frnd.