+ Reply to Thread
Results 1 to 2 of 2

Cutting and Pasting rows loopwise as per the same value in Proposal(Column E)

  1. #1
    Registered User
    Join Date
    02-24-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    76

    Cutting and Pasting rows loopwise as per the same value in Proposal(Column E)

    I have been trying to write a macro that does the task of cutting the set of rows and pasting them alongside the columns. I have a sheet named "current sheet" with Columns A to J.Column A consists of Companies name and so on. But every company has more than one Proposal#(Column E), Proposal Text(Column F) so on till Column J. My requirement was to get those second rows cut and pasted to the columns alongside the Column J. I have got it worked with the help of folks in this forum.
    Please Login or Register  to view this content.
    Now the output is like what i wanted but with slight variation. I need the same Proposal number (Column E) for each company to be pasted beneath. Example, Company "abc " has its Proposal 2 in Column Q but when I run the above code I get Company "efg" proposal 2 at Column K (i.e. beneath "abc"'s Proposal 1.2). You can look at the "Current output sheet". But I need it to be pasted beneath Column Q. Hope Some one will help as it is very urgent. the desired result is in sheet "desired output". Thanks in advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-24-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Cutting and Pasting rows loopwise as per the same value in Proposal(Column E)

    Can Anyone help me?

+ 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. Replies: 1
    Last Post: 11-22-2011, 06:28 PM
  2. Cutting and Pasting numbers in a column
    By ben5496 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2011, 05:15 PM
  3. ** Selective Cut and Paste - Cutting and Pasting Rows if a Row has Key Word in Column
    By brad70989 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2011, 06:04 PM
  4. Cutting/Pasting Rows based on content PT 2
    By Lmsloman in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-21-2006, 06:36 AM
  5. cutting a row and pasting to a column
    By wolfdogg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2005, 05:05 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