+ Reply to Thread
Results 1 to 3 of 3

VBA code to copy certain cells from one worksheet into a single row in another worksheet

  1. #1
    Registered User
    Join Date
    04-14-2012
    Location
    Paris, France
    MS-Off Ver
    Excel 2010
    Posts
    25

    VBA code to copy certain cells from one worksheet into a single row in another worksheet

    Hello all,

    I am trying to write a VBA code to copy values of certain cells from Worksheet A into a single row in Worksheet B; and every time I press on the "copy" button, the same cells in Worksheet A should be copied into the next row on worksheet B.

    For example, I want to copy the following cells from Worksheet A with this specific order: M1, H6, C9, L8, N8, L13, L15, L16, L17, C30; into Worksheet B as a single row. I.e. After being copied into Worksheet B, cell A2 will have the value of M1, cell B2 will have the value of H6, cell C2 will have the value of C9, etc....

    Any attempt at solving this issue will be appreciated.

    Thank you,
    HB
    Last edited by thedefense; 11-08-2013 at 06:11 PM.

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: VBA code to copy certain cells from one worksheet into a single row in another workshe

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-14-2012
    Location
    Paris, France
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: VBA code to copy certain cells from one worksheet into a single row in another workshe

    Hello Yudlugar,

    Thank you for the code it works perfectly!

+ 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. [SOLVED] copy data from cells in a column on one worksheet to a single cell in another worksheet
    By jpsnickers in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-03-2013, 07:02 PM
  2. copy values from different worksheet in one single worksheet
    By albertino in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2011, 06:26 PM
  3. Replies: 1
    Last Post: 02-13-2011, 06:20 PM
  4. VBA Code to copy a "criteria based" range of cells from worksheet A to worksheet B
    By xbaglione in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2010, 10:37 AM
  5. Replies: 1
    Last Post: 10-27-2005, 03:05 PM

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