Forum Discussion
Data gathering
This is your file with my formula copied to the summary sheet. The names had to be adjusted to the new situation but, other than that things went reasonably well. My intention is to show how an array of bidder reports can be generated by a single formula using a spilt range.
Here's an updated--using your database--version of the suggested format I gave you yesterday.
I had to clean up your main Auction data base first--to eliminate the rows you have at the bottom that do not belong in a clean Excel Table. These rows
(It's tempting, I understand, to add rows that do totals and the like, but they don't belong IN the table itself; do things like that off to the side.) Any single table should be nothing more than a single table, with adjacent rows and columns left blank. Ideally, not only blank, but rows below should be totally clear, so as to allow for added rows to the table.
If you want the Live Auction items to be part of the main database, just add them, and if they need to have something that identifies them as "Live" add a column or unique Identifier (e.g., L1, L2) in the first column. Don't have a header for "Live Auction Items" that breaks up the integrity of the table.