Help With A Spreadsheet for a silent auction
I am trying to create a spreadsheet to help with a silent auction. What I
would like to do is enter the winners bidder number as well as the winning bid in 2 columns corresponding to the item number. I originally thought of creating an individual work sheet for each item, then just entering the bidder number and winning bid in to each sheet and having the formula search through all the sheets. Either way, I need to then search through the information I have put in so that I can easily gather the total amount a bidder has spent, as well as the item numbers that they have won. If anyone can help, it would be greatly appreciated. If it would be easier to do it all on one sheet, or making separate sheets, whatever you can help with would be great. Thank you in advance. |
All times are GMT +1. The time now is 02:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com