Hello, Excel Pros,
I'm looking to have Excel enter a value (via macro, VBA, etc.) exactly two cells above a certain value whenever said value occurs in Column A.
For example, if Computer occurs in A8, A16, A50, I will want ABC123 to appear in A6, A14, A48, respectively.
Bookmarks