L
Lady Success
I want to create a macro that will allow the end user to insert select a row
anywhere in the worksheet and insert a blank row. Then if they enter data
into a specific cell, I want certain cells from the row above to delete.
For instance:
A1 Lipitor B1 $55 C1 $100
A2 Ambien B2 $100 C2 $150
If Row 2 is selected, and row is inserted, A2 data becomes A3. If data is
entered into A2, then the contents of B1 and B are deleted. The end result
would look something like:
A1 Lipitor
A2 Simvastatin B2 $20 C2 $40
A3 Ambien B3 $100 C3 $150
Can you help?
anywhere in the worksheet and insert a blank row. Then if they enter data
into a specific cell, I want certain cells from the row above to delete.
For instance:
A1 Lipitor B1 $55 C1 $100
A2 Ambien B2 $100 C2 $150
If Row 2 is selected, and row is inserted, A2 data becomes A3. If data is
entered into A2, then the contents of B1 and B are deleted. The end result
would look something like:
A1 Lipitor
A2 Simvastatin B2 $20 C2 $40
A3 Ambien B3 $100 C3 $150
Can you help?