| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I delete all matches in a workbook?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I delete all matches in a workbook?
Try asking that again and use the white space to give MUUUUUCH more detail
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "LiveUser" wrote in message ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I delete all matches in a workbook?
Yes. I am sorry. I sent the post before I typed the message.
Here is what I am trying to do. I have maybe 30 or so worksheets. On each one there is information that may or may not relate to each other. For instance, worksheet one has, Blue, Green, Yellow, Orange. Worksheet two has Blue, Red. Worksheet three has Red, Purple, Orange, Blue. I want to delete, in this example, ever color listed throughout the entire workbook without having to go through every page finding it and deleting it. I would like to just make a list that has: Red Orange Yellow Green Blue Indigo Violet Anything that matches this list will be deleted in the workbook. (In my real workbook I am not using colors.) I appreciate any help. And again, I am sorry for the mistake on the original post. "Bernard Liengme" wrote: Try asking that again and use the white space to give MUUUUUCH more detail best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "LiveUser" wrote in message ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I delete all matches in a workbook?
Chip has lots of stuff about duplicates. See www.cpearson.com
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "LiveUser" wrote in message ... Yes. I am sorry. I sent the post before I typed the message. Here is what I am trying to do. I have maybe 30 or so worksheets. On each one there is information that may or may not relate to each other. For instance, worksheet one has, Blue, Green, Yellow, Orange. Worksheet two has Blue, Red. Worksheet three has Red, Purple, Orange, Blue. I want to delete, in this example, ever color listed throughout the entire workbook without having to go through every page finding it and deleting it. I would like to just make a list that has: Red Orange Yellow Green Blue Indigo Violet Anything that matches this list will be deleted in the workbook. (In my real workbook I am not using colors.) I appreciate any help. And again, I am sorry for the mistake on the original post. "Bernard Liengme" wrote: Try asking that again and use the white space to give MUUUUUCH more detail best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "LiveUser" wrote in message ... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I delete all matches in a workbook?
Bernard:
Thank you for the info. I am not sure which VBA code, if any, I should use. I don't know if what I want is possible? "Bernard Liengme" wrote: Chip has lots of stuff about duplicates. See www.cpearson.com best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "LiveUser" wrote in message ... Yes. I am sorry. I sent the post before I typed the message. Here is what I am trying to do. I have maybe 30 or so worksheets. On each one there is information that may or may not relate to each other. For instance, worksheet one has, Blue, Green, Yellow, Orange. Worksheet two has Blue, Red. Worksheet three has Red, Purple, Orange, Blue. I want to delete, in this example, ever color listed throughout the entire workbook without having to go through every page finding it and deleting it. I would like to just make a list that has: Red Orange Yellow Green Blue Indigo Violet Anything that matches this list will be deleted in the workbook. (In my real workbook I am not using colors.) I appreciate any help. And again, I am sorry for the mistake on the original post. "Bernard Liengme" wrote: Try asking that again and use the white space to give MUUUUUCH more detail best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "LiveUser" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete certain text in a workbook | Excel Discussion (Misc queries) | |||
| How do I retrieve & view multiple matches from another workbook? | Excel Worksheet Functions | |||
| How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
| how do you delete a workbook | Excel Discussion (Misc queries) | |||
| how do I delete a worksheet from my workbook | New Users to Excel | |||
Hybrid Mode
