solsearcher
10-09-2013, 03:30 AM
Hello,
I'm sure this is a Excel macro job.
I have two sheets of data Sheet1 is the master with Columns A to O populated. Sheet2 has 5 Columns of data A to E, Column A of this sheet holds the same data as Column E in Sheet1.
I would like to add Columns B,C,D & E of sheet2 to columns P,Q,R & S of Sheet1 only if the Column A of sheet2 and column E of sheet1 match.
Could someone help?
I'm sure this is a Excel macro job.
I have two sheets of data Sheet1 is the master with Columns A to O populated. Sheet2 has 5 Columns of data A to E, Column A of this sheet holds the same data as Column E in Sheet1.
I would like to add Columns B,C,D & E of sheet2 to columns P,Q,R & S of Sheet1 only if the Column A of sheet2 and column E of sheet1 match.
Could someone help?