View Single Post
  #1   Report Post  
Barb
 
Posts: n/a
Default formula will not fill correctly due to odd number rows

I am using a formula to add sales in one workbook in the second book,
xxxx[2005 Sales 04.xls]Sheet1'!B9:B10), the problem is when I try to copy by
filling it assumes the rows are in order when in reality they are like this
b9:b10, b11:b12, b13:b14.... is there a way to do this, other wise I'll be
spending a lot of time editing.
Thank you and have a wonderful day