automatically deleting a cell formula

[Pugs107]

I have a sheet simialr to the one below:

Book1
	A	B	C	D	E	F
1	A	B	C	A	B	C
2	A	B	C	A	B	C
3
4
5	1	A	A		ENTER 1:	1
6	2	B	B		ENTER 2:	1
7	3	C	C
8	4	A	A
9	5	B	B
10	6	C	C
Sheet1

Data in rows 1 and 2 are entered based on data manually entered in cells F5 and F6. On occasion, data could be manually entered directly into one of the cells in row2. When this happens, I would need the formula in the cell directly above it in row 1 to be deleted. Is this something that is possible to automate?

-Thanks

 

[Pugs107]

bump

 

[mightymishra]

u can do this by writing a macro on "Worksheet_SelectionChange"
basically on selection change u activate a macro

 

[Pugs107]

Thank you very much Mightymishra.