Unfortunately, I am not able to change the structure, the people using the spreadsheet have been using it in this layout for the last 12 years and refuse to let me change it. (it has taken 3 years to get them to agree to moving it from Lotus 123 to Excel)
I am adding new functionality to a spreadsheet which is used to record amounts paid into a christmas club.
The main sheet has 1 column for week 1 and 2 columns for each other week. (this is to keep a running total and cannot be removed). When someone does not make a payment, it is entered as...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.