View Single Post
  #1   Report Post  
Brian
 
Posts: n/a
Default Display selected rows from one worksheet to another

Worksheet 1 has values in cells B1:G1 and down to B20:G20. I would like
worksheet 2 to display the values of each row of worksheet 1 only if the
value of cell D1,D2,D3 etc. of worksheet 1 is between 20 and 29. I would also
prefer not to have spaces between the rows in worksheet 2 when the selected
rows are displayed. I would appreciate assistance with a formula to do this.
Thanks in advance.