Creating Macro To Add Line

L

Lady Success

I'd like to create a macro to add a line anywhere on the worksheet and then
if something is entered in the blank row, specific cells in the row above it
are deleted. Can anyone help me with this?

For instance:
Row 6 Column 1 - Lipitor; Column 2 $120 Column 3 $80

I want to insert a blank row at Row 7 then if I enter "Simvastatin" in Row 7
Column 1, I want the contents of Column 2 and Column 3 in row 6 deleted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Macro 0
Macro to insert line 0
Mail Merge Help 1
Remove Identical words 0
Excel VBA macro, search - accumulate - delete original 0
Creating Macro & Macro Button 0
Look Up Formula With Veried Search Range 2
Macro and Macro Button 0

Top