Delete cells by cross-referencing another sheet

Q

qtownsend

New Member
Joined
Aug 4, 2011
Messages
2
I am trying to organize a school field trip through Excel. On Sheet1, I have a list of students who are registered. On Sheet2, I have the full class listings. My hope is that when I enter a registered student's name on Sheet1, that name will then be deleted from Sheet2. I would like it to be deleted because I have linked equations to Sheet2, so I don't want to just format the color so it looks hidden. Is this possible?
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Sort by date Sort by votes
It is possible through VBA.

You would want some kind of
Worksheet_Change() event in your Sheet1 module and work with that.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
List Results from All Sheets Search
2
Replies
16
Views
269
MikeVol
MikeVol
N
  • Question Question
VBA to add title from formula to a save as name
Replies
0
Views
138
NKUNZI
N
O
  • Solved
cross reference two cells in one sheet against two cells in second sheet - return data from third cell
2
Replies
13
Views
195
Fluff
Fluff
D
  • Solved
VBA Help - Command Button to copy data from one sheet to another
2 3
Replies
22
Views
1K
mumps
mumps
U
  • Question Question
VBA that will delete rows that have a matching value and automatically save as a pdf file after group/process
Replies
4
Views
312
Cubist
Cubist

Forum statistics

Threads
1,224,526
Messages
6,179,322
Members
452,906
Latest member
Belthazar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top