Awesome! Thanks so much, Joel!!

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"joel" wrote:


Your orignal posting didn't show columns E to G. You want to match the
following columns


B (2) to E (5)
C (3) to F (6)
D (4) to G (7)


You need to add 3 columns to the column number

From:
For ColCount = 2 To 4
FirstData = .Cells(RowCount, ColCount)
SecondData = .Cells(RowCount + RowOffset, ColCount)

To:
For ColCount = 2 To 4
FirstData = .Cells(RowCount, ColCount + 3) 'add 3 to get columns E to G
SecondData = .Cells(RowCount + RowOffset, ColCount)


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=197490

http://www.thecodecage.com/forumz

.