View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fester[_2_] Fester[_2_] is offline
external usenet poster
 
Posts: 12
Default Copy range to different columns depending on cell value

What I would like to do is look at a range (A6:IXXX), where XXX is the
last row of the range, and if there is NOT an "X" in I6, copy that row
to another range (K6:S6), this would look at each row and copy to the
new range if "I" is empty.

Is this possible to do?