I'm looking for something really specific, I've run into some problems and I haven't been able to figure it out myself.
I'm creating an interactive order form for my company and I need it to be able to do these things:
1) There's gonna be a cell where I'll put the number of items I'll be ordering. I want the form organized and formatted according to that number.
For example: I will be ordering 5 items. I need to create 5 rows, each of them properly formatted (width, height, cell type etc.) and in the first column (#) number from 1 to the number of items. Under the last row, I need "Total price" and a thick line under that. Everything below the line must be moved down according to the number of rows created.
2) I need a cell with a list. I would choose either EUR, USD etc. (string). Currency in general. I need the cells with prices to be formatted according to this.
For example: I know that the order will be in USD. I will choose the string "USD" from the list and all the prices will be like: $ 150,50 .. Then I change my mind and decide that it'll be in Euros. I will change the list option to "EUR" and all the prices will change to: € 150,50 .. I don't need anything about exchange rates, just display the price properly without having to change every cell manually. I do business in many currencies. I want it to be understandable for people with zero excel knowledge.
I know it's quite complex problem so I will be glad for any answer :-) Thanks very much.
I'm using Excel 2013. I hope I didn't misspell anything because I don't have the English version of Excel so I'm not sure what certain things are called.