Dear All
I want to enter a data in sheet1 and use same data in another sheet
i.e. sheet 1
Part no , Part name , rec qty, lot no
sheet 2
part no , part name, lot no , disp qty
so in sheet 1 lot no I want to use in sheet 2 lot no field with ref. of part no
in sheet 1 if five time same part with different lot no then in sheet2 after selection of part will show 5 lot no
any query please discuss
Bookmarks