I have a workbook that I have to make additions to every month. The
first three rows are headers and every month, I have to insert a row at
row 4.
On another worksheet, I have to work with the cells B4:B52 and D4:D52.
However, when I insert a row at row 4 every month, the worksheet
automatically change the formula to cells B5:B53 and D5:D53.
Is there a way to work with B4:B52 and D4:D52 regardless of what rows
are inserted??
Thanks.
--
ATK
------------------------------------------------------------------------
ATK's Profile:
http://www.excelforum.com/member.php...o&userid=27662
View this thread:
http://www.excelforum.com/showthread...hreadid=505644