Copying data from 2 Excel Sheets with common ID Haneef Puttur 15 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 .