thanks for the reply - sorry for the delay in getting back.
Have attached sample sheet (one empty line above the red border.
Starting in col A curser does exactly as required - jumping back to col A after stopping on each field that requires data entry (col I and M can remain empty).
All I am wanting to do is to insert cells A to M above the red line (and below the line just entered) that contains the correct formulas in the line ready for the next entry and updates the formulas using the extended column lengths.
I know it is simple but I just can't get the code right - DOH!
Regards
John
|