For a club we keep a simple record of weekly subscriptions- see attached Clubbook.xls. This is an Excel 2003 book. This is maintained by some-one who is not very computer savy.
1. We produce a weekly page showing who paid what.
I would like to do this automatically with the sheet picking up the data from one particular week. I know how to do this in Access but not in Excel.
2. When a member leaves we archive their contributions sheet to an archive workbook. I guess this could be done using some VBA.
I'd be ever so grateful with some tips on how to achieve this.
Lindie