christinewhittle
New Member
- Joined
- Feb 7, 2017
- Messages
- 11
i have two different workbooks and would like to copy & past from one to the other if certain data in one worksheet matches the other. If data in column A wb1 matches data in column A wb2 on wb1 column D will return the value of wb2 column D
workbook 1
A B C
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]12
[/TD]
[TD]misc[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]misc[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]misc[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]misc[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]misc[/TD]
[TD]70[/TD]
[/TR]
</tbody>[/TABLE]
work book 2
A D
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]17[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
i haven't used excel in a while and will appreciate some guidance please... TU
workbook 1
A B C
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]12
[/TD]
[TD]misc[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]misc[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]misc[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]misc[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]misc[/TD]
[TD]70[/TD]
[/TR]
</tbody>[/TABLE]
work book 2
A D
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]17[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
i haven't used excel in a while and will appreciate some guidance please... TU