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.
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.
Bookmarks