Dear Max.
Thanks for all your help and sincere reply.
Great. All that works fine.
But for me, not that much experienced in excel, it takes two days to
understand and make a trial. Now it is perfect. Welldone.
Thanks a lot for your help.
TT
"Max" wrote in message
...
Apologies, there were numerous typos within the entire para:
Inserting rows or deleting rows within the assumed data area in the
source
sheet: Y, ie within rows 2 - 2000 will upset things in X. If you cannot
help
this happening in daily ops, just restore things in sheet: X to working
order
by re-filling the top row formulas in Y's A2:C2 down to C2000 (In Y,
select
A2:C2, copy down to C2000).
Para should have read as:
Inserting rows or deleting rows within the assumed data area in the
source
sheet: X, ie within rows 2 - 2000 will upset things in Y. If you cannot
help
this happening in daily ops, just restore things in sheet: Y to working
order
by re-filling the top row formulas in Y's A2:C2 down to C2000 (In Y,
select
A2:C2, copy down to C2000).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---