- Registration date
- Sunday June 14, 2009
- Last seen
- July 30, 2015
not clear . what is meant by "sheet1.ENO=sheet2.ENO"
I suppose sheet11 has raju, ravi ramesh in column A2 to A4(row no 1 column headings)
and some data in columns B and C
in sheet 2
you have name "ramesh" in A2
you want to fill B and C in this sheet based on sheet 1
then you have to use vlookup function
post small extract of sheet 1 and sheet 2 as you want it to be.