Copying data from 2 Excel Sheets with common ID By Haneef Puttur | January 18, 2010 0 Comment We have Two Sheets. 1. Items 2. Sales Sheet (in this sheet Item name will be copied from items sheet) 3. Formula used .