Userform data to specific sheet

[aadil_1408]

Hello,
I have made a user-form sheet which takes in project data (description, project owner, status, updates, date) and outputs to a main sheet (Database). I needed to transfer the data from this database to different sheets according to the owner name in such a way that the daily update is recorded in a different row for that individual person. Although I recorded a macro for this using advanced filter copy, it replaces the data of the earlier dates with the new one instead of entering in a new row.
Please if possible suggest another way using VBA to do this.
Thank You

 

[fadee2]

hi aadil_1408,
welcome to tye board.....

use lastrow as your row address in your advanced filter. something like
????????

lr = Sheets("sheet1").Cells(Rows.Count, 2).End(xlUp).Row
then
advancedfilter........
....
copytorange:range("a" & lr)
....

hth....

 

[aadil_1408]

Hello Fadee2,
Thank you for suggesting the solution. I used your idea for auto filter instead of advanced filter and it worked perfectly.
Regards,
Aadil Khan

 

[fadee2]

you are welcome..... glad it helped.....???