I want to choose a row of data, paste it into a different worksheet, and have
the original worksheet update that a change has been made. It would
essentially act like a picklist. I pick the data from a particular row, it
automatically copies and pastes some of the fields to a new worksheet
underneath the last row of data copied and pasted. I try to just link
worksheets but this won't work because it creates 0's all over the linked
sheet. Thank you so much for your help!