View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kuansheng
 
Posts: n/a
Default copying data from matching cloumn

Hi,

I have in column K through W, column of data . The column heading is in
row K3:W3. In cell Y3 is the heading of a new column that the user will
enter. What i need to do is to find the matching cloumn heading from
K3:W3 and copy all the data from that column to the new column. Anyone
can help me out. Any help is appriciated, thanks you.