Help

[detrw4always]

I am trying to set up a spreadsheet for an auction service. I would like to know if it is even possible to do what I want. I have an excel spreadsheet that would be used to log in bid amounts and bidder numbers.

But before we even get there I would like to be able to on tabs, have those who bring us items, they name and info but then have a list of the items that they have brought to us listed much like this:
Item # Description

then on the "main sheet" the one we would use during the auction, have the item # and description automatically go from the sellers tab to the main sheet and vise versa, so that when we enter in a selling price and it calculates the commission wwe need to pay our seller that that info would tabulate to each sellers tab so at the end of the night I would have:

the main sheet with all the calcuations for the auction house such as sales tax, etc.....

The seller tabs would have the item number, the description, the selling price and the commision per item that would be due to them based on the agreed upone percentage.

Not sure if this really can be done or if it is an infinate loop.

 

[Meggesto]

Yes this could be done very easily I imagine. There are many ways to approach this too. From my understanding you'd like a single main spreadsheet with a few calculations that will populate information to various Seller's Tabs. Depending on how you compile the information you could code in VBA to disseminate that information across tabs from a main source. You could also just setup the spreadsheet manually linking each Seller's Tab to the respective information on the Main Sheet. The key here would be to make sure you keep everything uniform for the easiest flow of data between sheets and the main page.

 

[detrw4always]

Yes this could be done very easily I imagine. There are many ways to approach this too. From my understanding you'd like a single main spreadsheet with a few calculations that will populate information to various Seller's Tabs. Depending on how you compile the information you could code in VBA to disseminate that information across tabs from a main source. You could also just setup the spreadsheet manually linking each Seller's Tab to the respective information on the Main Sheet. The key here would be to make sure you keep everything uniform for the easiest flow of data between sheets and the main page.

Is there any place I can go to get help in developing this. I really want to learn how to do these things but am a novice when it comes to excel.

Thanks,

 

[shg]

Is there any place I can go to get help in developing this.

Main menu bar: MrExcel Consulting

 

[Meggesto]

If you were able to find this site and post here without to many problems you'll have no trouble designing something in Excel that can handle what you're looking to do. If you get stuck you already know you have a place to find an answer. There is a lot of information out there about how to use excel just search around. So long as you know how to open excel and begin putting information into cells you're nearly there. First think about how much information you're going to have. You'll need a column for the Seller's Name, Item Number, Description, Price, Tax, Commission and etc. Then you'll want to think about how you want the Seller's tab to look and try to replicate that same style for each Seller. Things you may want to look up.

Inserting a New Worksheet in a Workbook
Inserting a Formula into a Cell
Dragging a Cell's Formula to Other Cells
Linking a Cell to Another Cell

These are just some of the basics that should get you through what you need. Search for an example or two on line that may be able to help you visualize what you'd like your Auction Workbook to look like. You may be even be able to look locally to hire someone if you're very unsure of your ability to complete the project. I believe Mr. Excel does consulting too although they make take on tasks that may be a little more in depth and involve more code writing than designing.