I wish to construct Auction Lists for my Philatelic Society. At present I
make the list up in an Acces DB and then transfer it to Excel (2003). At
this point I add extra columns to cater for "Bidders #'s"; "Selling price";
"Price to Buyer";"Return to Vendor"; & "Return to Club", complete with
relevant formulae. So far so good, I now wish to add, at the base of these
columns, via a macro initially, a summary of data as entered. I also want to
show, and use, in order to locate this data, the "TOTAL NUMBER OF LOTS".
Simple, just count the "Lot #" column, no joy at all, and there doesn't
appear to be an answer in the HELP files. Has any body any ideas.
I could I suppose enter this number from the Access Database but would like
to make it fully self-supporting.