Jyotirmaya
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 216
- Office Version
- 2019
- Platform
- Windows
I have two sheets i.e DATA & RAW DATA
For example
sheet DATA
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]JANUARY[/TD]
[TD]FEBRUARY[/TD]
[TD]MARCH[/TD]
[TD]APRIL[/TD]
[/TR]
[TR]
[TD]TV
[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]20[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]MOBILE[/TD]
[TD]55[/TD]
[TD]0[/TD]
[TD]65[/TD]
[TD]88[/TD]
[/TR]
[TR]
[TD]LAPTOP[/TD]
[TD]0[/TD]
[TD]85[/TD]
[TD]55[/TD]
[TD]60[/TD]
[/TR]
</tbody>[/TABLE]
In RAW DATA sheet I am manually entering everything.
For example in Raw data sheet A2 i have entered TV, in January B2 I have entered value 10.
In c2 Feb column I can not enter any value. as in the main DATA sheet Feb is 0 for TV so IT should stop me from entering any value in Feb column. so how to do that ?? If i will enter any value in C2 in Raw data sheet it will check the main DATA sheet value, if it will have some value then only it will accept the value.
For example
sheet DATA
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]JANUARY[/TD]
[TD]FEBRUARY[/TD]
[TD]MARCH[/TD]
[TD]APRIL[/TD]
[/TR]
[TR]
[TD]TV
[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]20[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]MOBILE[/TD]
[TD]55[/TD]
[TD]0[/TD]
[TD]65[/TD]
[TD]88[/TD]
[/TR]
[TR]
[TD]LAPTOP[/TD]
[TD]0[/TD]
[TD]85[/TD]
[TD]55[/TD]
[TD]60[/TD]
[/TR]
</tbody>[/TABLE]
In RAW DATA sheet I am manually entering everything.
For example in Raw data sheet A2 i have entered TV, in January B2 I have entered value 10.
In c2 Feb column I can not enter any value. as in the main DATA sheet Feb is 0 for TV so IT should stop me from entering any value in Feb column. so how to do that ?? If i will enter any value in C2 in Raw data sheet it will check the main DATA sheet value, if it will have some value then only it will accept the value.