title: Selecting Cells Based on Criteria, then Copy and Paste Special (Transpose) - Macro Help
body: <p>I was wondering if anyone could help me with the following problem.  I have two excel workbooks.  Workbook A contains bill data running from 1 to 1000.  Each bill is on a different line in numerical order.  Workbook B contains bill sponsor information.  However, it is formatted as 1 sponsor per line, so 1 bill can occupy multiple rows.  Also, the bill number is in column A, while the sponsor name is in column B.  So, you have to select the names from column B based on the values from column A.</p>
  
  <p>I would like to select the names of each sponsor for each bill from workbook B and paste special (transpose) them into workbook A for each bill.  I can do this by hand, but it will take a very long time.  Is there anyway to automate it?  Thank you in advance.</p>
  
  <p>The data look like this</p>
  
  <p>Workbook A<br>
  Column A<br>
  1<br>
  2<br>
  3<br>
  4<br>
  5  </p>
  
  <p>Workbook B<br>
  Column A  Column B<br>
  1 Name ID<br>
  1 Name ID<br>
  2 Name ID<br>
  2 Name ID<br>
  2 Name ID<br>
  2 Name ID</p>