Search, Copy Paste Macro

Originally Posted by MarvinP

Hey crazyAMP

Add this line just before the "End With" Line

.Cells(Last2Row + 1, "H") = .Cells(Last2Row + 1, "H") - 1

This wokrs great to subtract one to the info it copies... but if possible I would like for it to subtract from the source (where it copeies the data frokm table 1) instead if possible Thanks ALOT