send data from one sheet to another sheet working with predicitive

[suresh mongam]

Hi frnds..



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.

[arlu1201]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.