301802 Excel Spreadsheet needed

I have a small business and I need a spreadsheet made that will help me with keeping track of prices of systems as their subparts' pricing changes.

I own a computer store. I sell computer systems that are built. Prices of parts change often.

Ideally I would like a spreadsheet where the first page has the parts broken down by category.

On following sheets, I would like to create systems, referencing the available parts from the first page. It would then total up the system with the latest available pricings.

As I get alerts from my suppliers that common parts are changing in price, I would edit it on the first page of the spreadsheet, and ideally it would change all the other sheets that reference that part number so I can see their bottom lines change.

I have attached an example sheet, without any of the referencing or dropdown functionality.

Is what I am imagining possible?

Thank you, and please message me if you have any questions.


Taidot: kaikki käy, Java, JSP, PHP, Visual Basic, XML

Näytä lisää: need java on my computer, java and excel, java alerts, excel spreadsheet business, excel help needed, excel help business, sell sheets, pricing excel, price excel, java+excel, java excel, excel java, create spreadsheet, small business spreadsheet, need spreadsheet built, php spreadsheet, small business excel, excel edit, create alerts excel, create page sell sheet

Tietoa työnantajasta:
( 4 arvostelua )

Projektin tunnus: #2047763