 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
|
||||
|
Eliminate data in sheet 1 from sheet 2 in excel
I've got 4000 names in Sheet 1 and I've got 200 names is Sheet 2. The names of 200 person in Sheet 2 also contain in Sheet 1. I would like to ask how can I eliminate names in Sheet 1 (4000 names) based on names in Sheet 2 (200 names).
|
||||
|
||||
|
Please explain more exactly what you want to happen and where. 1) The names in sheet2 should disappear from Sheet1? 2) The names in sheet2 should highlight on sheet1? To actually remove the names from the actual data on Sheet1 will require VBA. Is that OK? |
||||
| Question Tools | Search this Question |
Add your answer here.
Check out some similar questions!
How to connect one excel sheet to other excel sheet.
I used your explanation on connecting information from sheet to sheet in Excel and it worked great but I would like to know how to write the formula so that the value will change on sheet 2 when it is changed on sheet 1 automatically if I have to make any changes ? (I am doing year end receipts)
What I am trying to do is I have a schedule with drop down boxes I want to beable to click on a name in the dropdown box next to a time slot for appointments which are listed under the days date like a calendar, but once clicked I need it to update the list on the first sheet next to the same name...
I have attach what I have done on the site. What I need to do is link all of the data from sheet one to sheet 2. All I have found so far is how to link one cell to the other cell. In sheet 1 I have af 3 to af 699 . I need to bring all that data to sheet 2 to (d3 to d24) Sheet 2 will link into...
View more questions Search
|
