+ Reply to Thread
Results 1 to 2 of 2

delect values in Sheet1 and copy values from Sheet2 and then paste in Sheet1

  1. #1
    Registered User
    Join Date
    09-02-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    1

    delect values in Sheet1 and copy values from Sheet2 and then paste in Sheet1

    Hi Guys,
    I have data in rows in excel sheet1.

    Say the data sets in Sheet1 are:

    12 11 23 4 1 44 9 10 21 10 13 23 19 44 5 8

    I need to delet the content from 7th column onwards..then I have the values in A, B, C, D, E, and F columns and remaing are deleted. Here I deleted 10 points from '44' onwards..

    I need to add some new values (not neccessarily the same 10 number of values that I deleted) in the delected portions i.e. from col G onwards from Sheet2.

    But thing is, the data in Sheet2 are not in one row. I have data in two rows like this:

    1 3 4 2 0 5 4 1 4
    2 4 6 7 7 2 0 3 6

    I want to place them in a single row by just copying the bottom line and pasting besides the top row.

    Means, this should look like:
    1 3 4 2 0 5 4 1 4 2 4 6 7 7 2 0 3 6

    Now I need to copy the above line of the Sheet2 and to paste them besides the remaing of the row in Sheet1.

    Which looks like:

    12 11 23 4 1 44 1 3 4 2 0 5 4 1 4 2 4 6 7 7 2 0 3 6

    Can please help me guys..I shall be thankful to you if could come up with a macro to do the above........

    Regards, NP

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: delect values in Sheet1 and copy values from Sheet2 and then paste in Sheet1

    Hi,

    You don't necessarily need a macro.

    In J1 of sheet 2 and copied to R1
    Please Login or Register  to view this content.
    In S1 of sheet 2
    Please Login or Register  to view this content.
    Now copy J1:S1 down all your rows. Do a data filter on column S for the value 1 and then copy all the visible cells columns J:R and paste them to column G in your first row of sheet1.

    Regards
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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