LinkBack URL
About LinkBacks
Hello,
I have a set of 455 false entries in a large database of 3600 entries. How can I mark or highlight the false entries, can I put a macro over the xls file?
Regards
unielen
Hello,
I have a set of 455 false entries in a large database of 3600 entries. How can I mark or highlight the false entries, can I put a macro over the xls file?
Regards
unielen
What constitutes a "false" entry? Do you mean the cell contains "FALSE"?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
The false data entries consist of old not active e-mail adresses, which have bounced.
Okay, so do you have to test them one by one to see if they are legitimate or are they already flagged in some way?
One by one, and what I would like to do is take the list of 455 old and outdated e-mail addresses and lay them over the entire database consissting of 3600 e-mail adresses in 50 worksheets. Then they shall be highlighted and the eliminated/replaced. Is that possible?
And thanks so much Chemist B for your help. I need to be a little more clear: The addresses have been tested and bounced.
Okay, so you have a list of some 455 bad email addresses on one sheet. You want to use this list to mark the corresponding obsolete emails on about 50 other sheets (in the same workbook or different workbooks?)?
With that many sheets, we are probably talking about a macro solution.
(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)
- Click Advanced (next to quick post),
- Scroll down until you see "Manage Attachments",
- Click that then select "add files" (top right corner).
- Click "Select Files" find your file, click "open" click "upload"
- Once the upload is completed the file name will appear below the input boxes in this window.
- Click "Done" at bottom right to close the Attachment Manager.
- Click "Submit Reply"
Not the actual addresses just look likes
Ben Van Johnson
Okay, so you have a list of some 455 bad email addresses on one sheet.
Correct!
You want to use this list to mark the corresponding obsolete emails on about 50 other sheets
Correct!
(in the same workbook or different workbooks?)
IN The same workbook.
How do create and embed the macro?
As per ProtonLeah, it would help if you uploaded a sample workbook, showing how your data is set up on your bad email sheet and how it is set up on your email list sheets. (no need to have 50 sheets especially if the setup is similar on all sheets) My expertise is a little shaky with creating something like this but this will be a snap for some others in this forum.
Ok I uploaded two files, one sample database and one sample false e-mail addresses, the same way as I have my database. Now I would like to lay the false ones over the main databse and highlight them.
Non-macro option:
sort the list of dead e-mail addresses A-Z
in the current list workbook, using a helper column (D) on each tab
select sheet1. Shift-select the last sheet to group them.
In D1:
Replace 'C:\[Sample false e-mails unielen.xlsx] with the path & name of the actual dead list file
Please Login or Register to view this content.
use the fill-handle to fill down to the last used row.
select sheet1, then select Columns A:C and apply conditional format formula: =$D1>0
Use the format painter to copy the format of a cell on sheet1. Group-select the remaining sheets and apply the format to columns A:C
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks