kshitij_dch
Active Member
- Joined
- Apr 1, 2012
- Messages
- 362
- Office Version
- 365
- 2016
- 2007
- Platform
- Windows
Hi all
i have 2 workbooks
wb1(mi report.xlsx ) and wb2(stafftime.xlsx)
wb1 has 2 columns Column "H" (ID"S) and column "I" (Durations)
wb2 has 2 columns column "E"(ID"S) and column "I" (durations)
want a macro which will pick column H and I of WB1 and open WB2 match the ID'S of column H with list if ID"S in column E of WB2, in front matched ID"S in WB2 , Column I(durations) of wb1 gets pasted in column J of WB2.
i have 2 workbooks
wb1(mi report.xlsx ) and wb2(stafftime.xlsx)
wb1 has 2 columns Column "H" (ID"S) and column "I" (Durations)
wb2 has 2 columns column "E"(ID"S) and column "I" (durations)
want a macro which will pick column H and I of WB1 and open WB2 match the ID'S of column H with list if ID"S in column E of WB2, in front matched ID"S in WB2 , Column I(durations) of wb1 gets pasted in column J of WB2.