sheet1
col A ---- col B ---- col C
1 name date salevalue
2 John 7DEC05 175$
3 Lara 7DEC05 524$
Find if "John" sheet exists in this workbook then copy b2:c2 and paste them
in "John" sheet last empty row,next find if "Lara" sheet exists in this
workbook then
copy b3:c3 and paste them in "Lara" sheet last empty row,like that loop this
task
end of last row of sheet1.Any body pl.give me complete code.