Auto fill in

[António Rodrigues]

Dear all,

Hope you are doing fine. This is my first time posting in this forum!

I work in a Pharmaceutical Industry company, and I am currently improving a database of products vs clients (in excel) in order to ease the filling in of values. I am currently dealing with this difficulty: every product (medicine) has different dosages and presentations (28 mg in a box of 20 tablets; 56 mg in a box of 40 tablets and so on). We currently have to fill in a different row for each presentation. As an example:

Book1.xlsx

As there are repeated values from line to line, my idea was to type the values in the first line only. In the lines below, if I would type ANYTHING in "dosage" or "box", the columns A-E would auto fill in immediately.

Initially, I thought of using the following function IF(OR(($F2<>"";TRANSPOSE(A2);"");($G2<>"";TRANSPOSE(A2);"")). The problem is that there are many situations in which I have to fill values in blank rows in the midst of the table. Therefore, I would have to copy-paste the formulas there, so this represented double work instead of half work

Is there any possibility to do what I want without a macro or VBA? I ask this because I am affraid the document turns too heavy or unstable. It is really important that the workbook runs smoothly.
If there is not any possibility at all, please be so kind as to compile a code for me, because I do not know how to do it.

Thank you in advance for your attention.

[Cheeky Charlie]

http://www.exceltip.com/show_tip/Exc...ta_/30104.html

[António Rodrigues]

Thank you, that method will do for the cells that I have blank now.

But I actually meant a method in which excel would fill the blank cells without any indication / click / anything. I wanted it to be possible just to type in the values that vary from line to line, and the values in the other columns would fill in automatically. Is it possible to do that?

Thank you again for the quick reply

[Cheeky Charlie]

You could automate something to do that with a macro, but you'd have to be more specific about what you wanted to replicate from where, based on which rules. In essence some code that looks like: "If someone types in column G, copy down the contents of columns A:F from the row above" would be very easy, but would need specifics.