cutting and Pasting through a loop based on the count of unique company names

Hi,

I am trying to code a vba script that cut and paste the set of ranges (from Column E : Column I) for each company name(Column A) and proposal# in (Column E) into the same worksheet. I have been trying for a while. Please find the attached workbook of input sheet and desired worksheet.

It is better to describe what you want - could there be duplicates of combinations of A & E or are they unique? (i.e., one row per new worksheet or multiple rows). Do you want to choose the values to export, or export all possible combinations?

And, finally, why not just filter on A and then E to show the same information that you would see by having it on a new worksheet?

I am trying to get a solution such that from the input sheet("Current") i am trying to make one row per company that would make all the subsequent Columns i.e. Proposal#(Column E), Proposal Text(Column F), BNYM Rec (Column G) to be moved on to columns J:X. Column E is unique but now Column A will have unique Company Name but with empty cells for the following Proposal#. Both are distinct. I need the final as a worksheet as I will be working on it to populate to word template using bookmarks. I guess you get my point? Thanks for help.

Hey Guys I have attached another sample sheet. Thanks in advance.