Closed Thread
Results 1 to 2 of 2

Macro to copy and paste based on a column

  1. #1
    Registered User
    Join Date
    01-23-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    9

    Wink Macro to copy and paste based on a column

    Hi ,

    I need an help in creating macro for doing two tasks

    1.To copy the data from one sheet to new sheet in same excel based on a particular column.Column C will have multiple values and these values might repeat ,so i need the macro to put filter on that column and copy paste the relevant details to new sheet for all the values in that column.

    2.The other macro has to paste the data in a specified order in a different excel sheet.For this the output given by first macro will be used, the new sheets which the first macro created will be pasted in a order in different excel by using second macro.

    First Macro Order to copy paste in second Macro
    Column B Column C
    Column E Column G
    Column D Column E

    The column B of first macro has to be pasted in column C by using the second Macro in the similar way the other two columns also has to pasted.Once this done it has to leave a line and again it has to paste the same data.

    Can you please help in doing this.
    I have attached the outputs of the two files to show how it looks.
    I hope this helps in creating a macro.
    Eagerly waiting for a quick reply.
    Attached Files Attached Files

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Macro to copy and paste based on a column

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

Closed 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