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, spreadsheet need track, EDIT EXCEL, small java questions, excel business, small excel

Tietoa työnantajasta:
( 4 arvostelua )

Projektin tunnus: #2047763