+ Reply to Thread
Results 1 to 3 of 3

Copy selected cells/rows to another worksheet _

  1. #1
    Registered User
    Join Date
    09-10-2009
    Location
    Morrison, Colorado
    MS-Off Ver
    Excel 2016
    Posts
    10

    Copy selected cells/rows to another worksheet _

    Hi Jokacave,

    Don't mean to hijack thread, but it seams that they are not replying and my issue is somewhat the same.

    Please see attached:

    I would like to be able to select a row in Sheet ONE, either by entering row number or check box, clicking button (?), and have it fill in specific cells in Sheet TWO. If you look at Sheet TWO, I hope this makes sense.

    Sheet TWO will be a printable form; it's cells filled in by the row that is selected in Sheet ONE.

    Thanks very much,
    Mike
    Attached Files Attached Files
    Last edited by mcm1009; 09-26-2011 at 11:42 AM.

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Copy selected cells/rows to another worksheet _

    I added this macro on sheet 'one'. When you double click in a cell in sheet 'one' macro will transfer data in sheet 'two':
    Please Login or Register  to view this content.
    Regards,
    Antonio
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-10-2009
    Location
    Morrison, Colorado
    MS-Off Ver
    Excel 2016
    Posts
    10

    Re: Copy selected cells/rows to another worksheet _

    Hi antoka05,

    This is a cool way to transfer row data. Thank you very much.

    (I'm sorry that I added a new post requesting the same thing ... i was informed not to hijack a thread and it appeared my post was deleted. I will remove my 2nd post. thank you.)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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