Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Displaying Text
I am building a macro (below) which changes the text "This is Brown colour" to "Brown" in col D. This works perfect. now in Col G (same row) I need to add "A" if the result in D is "Brown" and "B" if the result in D is "Red". Please help. Sub Adv_Cert() ' ' Adv_Cert Macro '...- gauca001
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Compare two sheets and delete matched rows.
Sheet 1 is my master data. Sheet 2 is a newly supplied list. I need to match column D in sheet 2 to column E in sheet 1. Then the macro is to delete the entire matched rows in sheet 2 only, leaving only those unmatched. Attached is a sample file. Thanks Tony- gauca001
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
