View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Filter column A and copy column if cell in row has header

Hi Howard,

Am Tue, 7 Apr 2015 10:33:37 -0700 (PDT) schrieb L. Howard:

row y with MyHdr in columns 3,7,9 (each column a different length)would copy 3,7,9 to sheet mySheet next to row x data.

row z with MyHdr in columns 2,6 (each column a different length)would copy 2,6 to sheet mySheet next to row y data.


how to find row x data in mySheet?
Can you provide an example workbook with data in mySheet?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional