Teylen,
Thanks for the quick response.
After seeing your post i notice I left one thing off. The formula i provided executes in column M so what it really looks like now is:
Sub InventoryCheck()
Range("M2").Select
ActiveCell.FormulaR1C1 = "=ISNUMBER(MATCH(RC[-12],Sheet2!R1C1:R6053C1,0))"
Dim LR As Long: LR = Range("B" & Rows.Count).End(xlUp).Row
Range(Cells(3, "M"), Cells(LR, "M")).FormulaR1C1 = Cells(2, "M").FormulaR1C1
End Sub
I believe the array of R1C1:R6053C1 covers point #1. (Sorry, I am getting into the habit of figuring out my problems while i write up the posts).
Now point #2 is not so easy for me because I have not really attempted any conditional formatting within a macro.
How would I code "if M2 = TRUE then make Row 2 BOLD, if not leave it as it is.
This leads me to a 3rd question of do I really need to have the code in point #1 return a value in M or can it just "run" through the provided array and if it finds a match between Sheet1 and Sheet2 it bolds that row??
Sorry if I am losing you on this one.
Bookmarks