I am attempting to make a range of cells' data be deleted if a cell outside of that range that had a name in it is no longer there. So if I have a list of names in cells A1:A6 and a range of data in cells D10:E20 that corresponds to a name in cell A2. If the name in A2 is deleted I would want the data in D10:E20 to be deleted. If anyone can help me I would really appreciate it.
You can have a macro do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I do not have much experience in macros, do you have one in mind?
You can try this - i couldnt get it done any other way so used the double click option. You double click on the cell which you want deleted and the macro will take care of the rest -
Right click on the sheet name which contains the data, select View Code and copy this code into the window that appears -
Please Login or Register to view this content.
Just wondering where it says "Target", "Cell", "range", "value" or "dtext" if I should be putting in values there and if so what values?
No you do not need to put values in the code. You should just double click the cell which you need cleared from A1:A6 and the rest will be taken care of by the macro.
When I just copy and paste that code in, I click the play button, which is what assumed made the program run. Once I clicked that a prompt came up asking me to name the macro and create it and once I did that, A new sub was started and mine did not run. I am just confused as to how to get the code to start working.
You need to right click on the sheet and select View code. Copy the code i provided you. Then just double click on the cells in column A in the range 1:6 and the corresponding cells will get deleted in the other range.
Yeah that isn't working at all. Have any another suggestions?
It worked when i ran it. Can you attach a sample of the file you are using so i can check?
You wanted the macro to delete the entries in the 2nd range once you delete the entries in the 1st range right? In this case, you do not need to delete but double click the entries in the 1st range and automatically the same entry in the 2nd range would be deleted. The double click will delete the entry in the 1st range too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks