Do not allow user to input different value than in row above in table

[jaryszek]

Hi,

I have table with first row in table which is constant.

Screenshot_23.png

User is not changing the first row!

Ok but in G7 i would like to have calidation that he has to input the same value as in row 1.
In G8 the same (1 row above ahsa to be the same).

How to create validation for it? It can use Inputmessage or something but block user before it!

In other words user can not change formulas and values from first row in columns.

Jacek

[AliGW]

Explain why the user would need to enter anything. If all rows have to be the same, then generate the table automatically.

[jaryszek]

thanks Ali,

sorry i should put one additional column where user can change value.

So he is not allowd to change values in Col1, Col2 and Col3 but in Col4 he can.

Jacek

[AliGW]

So what should the user enter? A value or a formula?

[jaryszek]

In Col 4 he is inputting Value.
For rest columns she is not allowed to change value. He can input value but has to be the same like in previous row for the same column.

Screenshot_24.png

Co in Col1, Col2, Col3 he hast to input the same Value like in previous row.
But for Col4 he can do what he wants - input value or formula.

Best,
Jacek

[JeteMc]

As I believe Ali is suggesting in post #2:
1. Modify cell G6 to read: =C$2 and then select to Overwrite all cells in this column with this formula
2. Similarly modify cells H6:I6
When cell J7 is selected and the tab key is pressed, G8:I8 will automatically fill with 1, 2 and 3 respectively.
Let us know if you have any questions.

[jaryszek]

Hi,

i tried your way JeteMc thanks! - is very nice but it is not guaranteing that Col1, Col2, Col3 will be changed by user.

I want to just add validation to not input something different than in row above for certain columns.
Maybe only VBa is solution?

Jacek

[jaryszek]

Anyone?

Jacek

[bebo021999]

Use datavalidation in G6 then copy to next column

[jaryszek]

Hi Bebo,

thank you!

I tried yoyr method but without any issue i added 3rd row with not validation inside (just went one cell above and write "44"):

Screenshot_27.png

Jacek

[bebo021999]

Try to copy above row, then paste special/choose "Validation" into new row

[jaryszek]

hi Bebo,

you mean to copy first for example 100 hundreds rows for validation only and if user wil try to input validation is already there?

Jacek

[bebo021999]

Yes. Just copy validation only.