View Single Post
  #7   Report Post  
Max
 
Posts: n/a
Default

Correction wrt insertion point in Sheet1, apologies:
In Sheet1, select row4 before you insert new row (instead of row3)
This ensures the formulas in Sheet2 will auto-cover the extended range
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----