+ Reply to Thread
Results 1 to 3 of 3

Copying a selected row on sheet 1 to data entry sheet by pressing a button through macro

  1. #1
    Registered User
    Join Date
    08-22-2014
    Location
    india
    MS-Off Ver
    2010
    Posts
    4

    Copying a selected row on sheet 1 to data entry sheet by pressing a button through macro

    hello everyone ,
    I am very new in macros, so don't have much knowledge. I am trying to copy a selected row from Sheet named as sheet 1 to the next blank row on sheet named as data entry. But every time I am trying to do so, I am getting the same in Column A with Transpose set to True, but when I am setting transpose as False , getting Runtime error 1004 with paste method not correct.



    I am attaching a sheet in which If I am using Module 2 I am getting the contents in same row on data entry sheet every time I select a new row on sheet 1 and press button 2, and when I am using module 3 I am getting the contents in next empty column every time I am pressing button Data Entry.

    My requirement is that every-time I pressed a data entry button data should be copied in next blank row of Data entry sheet.

    Hoping that someone help me out of this situation.

    Thanks & Regards
    Amandeep Singh
    Attached Files Attached Files

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Copying a selected row on sheet 1 to data entry sheet by pressing a button through mac

    I think you meant it this way:
    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  3. #3
    Registered User
    Join Date
    08-22-2014
    Location
    india
    MS-Off Ver
    2010
    Posts
    4

    Re: Copying a selected row on sheet 1 to data entry sheet by pressing a button through mac

    Thanks it works!!!Thanks alot!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-12-2016, 03:36 AM
  2. how to create macro button to print a selected area of sheet2 from another sheet
    By EMAIL4DEEPAKRAJ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2015, 06:29 AM
  3. [SOLVED] Export entered values into a different sheet by pressing a button
    By mils in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2015, 08:20 PM
  4. copying selected data from sheet to new sheet
    By neilclelland in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-29-2013, 09:17 AM
  5. Preventing duplicate entry of a row in Sheet 2 while copying selected rows from Sheet 1
    By Pavan Renjal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-31-2012, 04:27 PM
  6. [SOLVED] Macro for copying data from one column in sheet 2 based on two criterias in sheet 1
    By baardings in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2012, 01:50 PM
  7. Replies: 2
    Last Post: 09-10-2012, 03:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1