Cells & tables formats depending on another cell content

December 17, 2014 at 06:54:20
Specs: Windows 8

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.


See More: Cells & tables formats depending on another cell content

Report •

December 17, 2014 at 20:29:07
This project is going to require a macro. In order to accomplish this, we would need all of the detail related to the formatting of the rows, the location of the cell that will accept the number, the location of the list and all of the values in that list.

However, I have a question for you...

What are your plans for those inevitable times when the user enters a 5 and the form get set up based on that number. Then he starts to fill in the rows and realizes he needed 6 rows, or 4 rows, etc?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question