Hello,
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.
3) I'll also need a cell with another list, where I'll choose my supplier and his address and other information will be put in the correct cells automatically (table with this information will be in another list)
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.
Cheers,
Thomas.
Bookmarks