Hey, i have 2 identically laid out workbooks. one that has a list of all product codes in column B, Item Description in Column C, Branding image in column D and image location in Column E. In the second we have the same layout just blank data. I'm trying to add product codes in column B but the for Column C,D and E to Look up the data from the first Sheet and pull it through automatically as Text rather than a formula. However i cant seem to even get it to look it the data to start with.
Any help appreciated
Any help appreciated