See if it helps : -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bom Sent: Monday, August 22, 2011 4:40 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Copy and paste
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 -- ---------------------------------------------------------------------------------- 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
CopyPaste.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
