I want to create a data entry form, where the users will type required information in some cells, then press a add button to transfer these data into a table within the same sheet, when they press add, data are added and the entry cell are reset, I saw good example in this forum, but I can not change the pasting destination, I can move between rows, but not across columns,
http://www.excelforum.com/excel-prog...ml#post3426509
any idea?

Thank you