Also I would like to update the 'Archive' workbook without removing the previous updated entries.
For example, when using the VBA code 2: Copy entire row to another sheet based on cell value I am wanting to copy rows from one sheet to another, based on whether column J has a "Y" entered.
But I want to copy the same rows 1 and 3 but the cells from D until H and not the data in A, B and C. You could even change the If statement to consider "active" vs. Activate Dim LastRow As Long With ActiveSheet LastRow =. Next times, only rows which B-column font is NOT bold will copy.
This could be selection rows based on certain criteria or it could be summing data. Excel vba copy rows to another worksheet based on criteriaĮxcel vba copy rows to another worksheet based on criteria Selection.