I came across your article "copy multiple cells (not in range) from one sheet to another sheet". I copied the VBA Macro and pasted it, referenced the cells in a hidden row and assigned a button to execute. it works fantastic from one sheet to another sheet in the same workbook. My problem is I need to copy from one workbook sheet1 (invoice) to another workbook sheet1 (accounts receivable with aging). Can the existing VBA code be adjusted to do that?
These are the changes I did to the VBA Macro to suit my ranges
wks1.Cells(use_row,1) = wks.cells (50,1) wks1.Cells(use_row,2) = wks.cells (50,2) wks1.Cells(use_row,3) = wks.cells (50,3) wks1.Cells(use_row,4) = wks.cells (50,4) wks1.Cells(use_row,5) = wks.cells (50,5) wks1.Cells(use_row,6) = wks.cells (50,6)