Hi there, I'm trying to several thousand new stock items from the manufacturer sheet to an old stock sheet without repeating stock that's already in the old spreadsheet, and once the new row (stock item) has been added to the old sheet, the Part no. cell then needs highlighting (preferably green) to show that it's new.
Our spreadsheets are laid out A = Part no. B = Price. C = description.
D = RRP, E = EAN NO. F = Weight (KG)
Hopefully I made sense of that, any help is appreciated, thankyou.
Bookmarks