+ Reply to Thread
Results 1 to 3 of 3

Cant insert new row and copy data

Hybrid View

  1. #1
    Registered User
    Join Date
    04-30-2010
    Location
    Fairmont,WV
    MS-Off Ver
    Excel 2007
    Posts
    66

    Arrow Cant insert new row and copy data

    I have a spreadsheet with data that has been copied onto it. Column A is the key column. What I need to happen is this. If there is data in the columns past H,( I through O) I need to insert a new row directly under the row in question and copy and paste the next SEVEN cells into it...pasting it in the new row, column B and continuing to Column H.
    Now,keeping in the same row, If there is data in the cell (column P), do the same...insert a new row under the row just made and copy n paste the next SEVEN cells into the row starting at column B through H.
    This needs to be done once more if there is data in column W.
    I need this to be done on the entire spreadsheet.
    I attached a small spreadsheet to show what I need.I appreciate any help.

  2. #2
    Forum Contributor ianh's Avatar
    Join Date
    11-19-2010
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    114

    Re: Cant insert new row and copy data

    cant see the attachment

  3. #3
    Registered User
    Join Date
    04-30-2010
    Location
    Fairmont,WV
    MS-Off Ver
    Excel 2007
    Posts
    66

    Re: Cant insert new row and copy data

    Attached sheet
    Attached Files Attached Files

+ 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