Thanks ...It was very helpful. On Aug 22, 1:37 am, "Rajan_Verma" <rajanverma1...@gmail.com> wrote: > 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 athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel > > > > CopyPaste.xlsm > 23KViewDownload
-- ---------------------------------------------------------------------------------- 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