If cell is blank in specific range the on the same cell in another sheet should come yes

[Sunil7598]

Hi Guys,

I have to sheets. one with data and other one is has only headings.

for example if in Sheet1 any cell is blank in given range then in sheet2 on the same cell address it should enter no. Vise versa.

I tried few codes but unable to read cell address and change value in next sheet.

Kindly help me

Thank you

 

[James006]

Hi,
You could test

Private Sub Worksheet_Change(ByVal Target As Range)
 Sheet2.Cells(Target.Row, Target.Column).Value = "Yes"
End Sub

 

[cadandcode]

Kitap3.xlsx.xlsm
	A
65	1
66	a
67	2
68	b
69
70	d
71	e
02.02.23

Kitap3.xlsx.xlsm
	A
65	1
66	a
67	2
68	b
69	NO
70	d
71	e
03.02.23

Cell Formulas
Range	Formula
A65:A71	A65	=IF('02.02.23'!A65="","NO",'02.02.23'!A65)

 

[Sunil7598]

Hi,
You could test

Private Sub Worksheet_Change(ByVal Target As Range)
 Sheet2.Cells(Target.Row, Target.Column).Value = "Yes"
End Sub

thanks man,

That worked perfectly.