Copying data from 2 Excel Sheets with common ID Haneef Puttur 14 years ago We have Two Sheets. 1. Items 2. Sales Sheet (in this sheet Item name will be copied from items sheet) 3. Formula used .