We generate daily updated work lists. What I need to do is take a job number from today's list (for example we'll call it Tab 2 cell A2) and compare it to yesterday's work list.
Tab 1 = yesterday
Tab 2 = Today
What I want is if Tab 2 Cell A2 appears anywhere on Tab 1 then print the notes from tab 1 (column J for that corresponding row) onto Tab 2 cell J2
I don't even know where to start. I tried but got nowhere with if/then logic.
Please help
Bookmarks