+ Reply to Thread
Results 1 to 2 of 2

How to paste every third row in Excel, please help!

  1. #1
    Registered User
    Join Date
    06-10-2014
    Posts
    1

    Smile How to paste every third row in Excel, please help!

    Hi all,

    I have just started using Excel and I have a very very basic knowledge of Excel, but I need it for work. I have 8 columns of data that needs to be alternating every third row by subject data, however there is no option under "paste special." I have been googling and I think I might need a "macro" but I am not sure. The values for each cell are unique and do not repeat.

    The format should be like this:

    1st row =subject A data
    2nd row =subject B data
    3rd row =subject C data
    4th row =subject A data
    ect..

    For example how it would look in Excel:
    A1 A2 A3 A4 A5 A6 A7 A8
    B1 B2 B3 B4 B5 B6 B7 B8
    C1 C2 C3 C4 C5 C6 C7 C8
    a1 a2 a3 a4 a5 a6 a7 a8
    ect.. where Letter# would be a numerical number (such as A1= 101, B2 =93, ect)


    There are 45 rows for each subject pool, for a total of 135 rows (which should be alternating by subject data) and there are 8 columns.

    I would appreciate any help/suggestions! I have never coded before so this is all new to me.
    Thank you in advance!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: How to paste every third row in Excel, please help!

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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] Excel 2010 - Paste Values with Paste Transpose at the same time
    By phillyfilly in forum Excel General
    Replies: 3
    Last Post: 11-05-2013, 04:23 AM
  2. [SOLVED] ActiveSheet.Paste Link:= True Does Not Work After Awhile - 1004 MS Excel cannot paste data
    By zfeinstein in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2013, 04:28 PM
  3. Replies: 1
    Last Post: 12-05-2012, 11:37 AM
  4. Replies: 1
    Last Post: 10-01-2012, 11:11 PM
  5. Replies: 3
    Last Post: 12-09-2005, 01:20 PM

Tags for this Thread

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