automatically deleting a cell formula

Pugs107

New Member
Joined
Nov 18, 2005
Messages
19
I have a sheet simialr to the one below:
Book1
ABCDEF
1ABCABC
2ABCABC
3
4
51AAENTER 1:1
62BBENTER 2:1
73CC
84AA
95BB
106CC
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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

mightymishra

Board Regular
Joined
Oct 18, 2002
Messages
65
u can do this by writing a macro on "Worksheet_SelectionChange"
basically on selection change u activate a macro
 

Watch MrExcel Video

Forum statistics

Threads
1,118,436
Messages
5,572,094
Members
412,441
Latest member
kelethymos
Top