strangerhere
New member
- Joined
- Jan 24, 2012
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Looking to create a macro for the following scenario:
Workbook1 contains Sheet labeled: New Input Sheet (copy from)
Workbook2 contains Sheet labeled: New Input Sheet (copy to)
I want to copy each value related to the Defined Name from Workbook1.New Input Sheet that matches the Defined Name in Workbook2.New Input Sheet
So.. for example, Workbook1.New Input Sheet has a Defined Name = ProjectName with a value: Mobile Device Project
I would want to copy that value (Mobile Device Project) to Workbook2.New Input Sheet (into the cell with the Defined Name = ProjectName)
Workbook1 contains Sheet labeled: New Input Sheet (copy from)
Workbook2 contains Sheet labeled: New Input Sheet (copy to)
I want to copy each value related to the Defined Name from Workbook1.New Input Sheet that matches the Defined Name in Workbook2.New Input Sheet
So.. for example, Workbook1.New Input Sheet has a Defined Name = ProjectName with a value: Mobile Device Project
I would want to copy that value (Mobile Device Project) to Workbook2.New Input Sheet (into the cell with the Defined Name = ProjectName)