Add data to a sheet present in add-in

Hello everyone,

I am a complete newbie to excel-vba programming. I am now developing an add-in that has a worksheet containing 3 cols and about 200 rows.

What i am trying to do is,

when the add-in is invoked, it searches for a particular value(user-specified) in add-in worksheet and if present it should add it to current worksheet.
but when i want to add a new row/col,through userform, to the sheet in add-in, it is not adding it.(i am using the sheet in add-in as kind of storage, so i may need to add a new data)
It worked well when i used the program in personal.xls file, it added the data to the sheet in personal.xls

so can some give me an idea how to add data to a sheet in add-in??

Thanks in advance,
sathya