So sheet 1 has a whole heap of information on it. I want to be able to type a load number in C7 on sheets 2. Which will match a load number in Column R in sheet 1. I then want information from certain columns that have that load number from sheet 1 copied onto sheet 2.
Please see the attached file
Thanks in advance
Bookmarks