Don't know what happened over there, but here's a revised set-up for your
easy ref with some additional row/cols inserted to provide immediate
"flexibility" for use as a template:
http://www.savefile.com/files/612401
Club_Membership_Fee_Apportionments_v2.xls
You should be able to insert rows/cols as per normal here w/o impacting the
formulas' functionalities, as it does not contain any row/col sensitive
functions within, such as ROW(), COLUMN(). The cell refs will adapt auto. Be
careful, though with row/col deletions. Deletions might mess up formulas.
Avoid deletions.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Qazi Ahmad" wrote:
Dear Max
Thank you, great help and highly appreciated.
It really solve my problem. I need one more help in this excel sheet. I want
to insert some empy rows and colum in begnning. But when I insert rows colum,
the formula be come wrong #Value!. Please tell me how I insert rows and
colum