View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eán[_2_] Eán[_2_] is offline
external usenet poster
 
Posts: 30
Default Formula or Macro

I need to write a formula or macro that would allow me to do the follow:

If cells $F$3:$F$70 contain "Very High" and cells $G$3:$G$70 contain "Very
High" in sheet1 I need the whole line A:K to be repeated on sheet2.

How do I do it please?

Thanks