Hi everyone!! Just wondering if this is possible....create a command that will copy the data I have selected and paste it to another worksheet. Also, I need the copied data to be placed in the next blank row in the other worksheet. Now here is where I can not find my answer. I need the "selected" data to change. Example: Rows 5-10 and Columns A-F are full, and I select Row 3 with Columns A-F and press the "command button." I would like it to copy what I selected and paste it in another worksheet. Also, I need the copied data to find the next available row in a range. Meaning, it can only paste in Rows 10-40 and Columns A-F.
I would greatly appreciate any advice on this matter. Thanks! -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
