Hello everyone.
So I am relatively new to excel and I have been solving problems as I go on this project that I have taken on.
I have this macro built and am trying to solve a problem with referencing text information from a different worksheet.
My goal is to reference the information in column B on worksheet 2 and insert it into column B on worksheet 1 corresponding to the correct WO # found in column A on both.
This is updated daily and my information in column A is constantly shifting up and down when new orders are added or removed and I am trying to figure out how to get my notes to "follow" the new layout of information on sheet 1.
I have attached an example workbook. Any and all help is greatly appreciated. THANK YOU!
Bookmarks