myworkbook tab (roster) c22 down to c20002000 I am trying to do a VBA to a button that I can click and it will put all the info I need from another workbook called (Master Roster) tab current roster con and from tab current Roster ORL. to myworkbook tab roster from c22 on down. I am using excel 2007