HI,
I am trying to copy Range W3 from sheets "Pay10" to "Pay26" in one workbook to a sheet called "Data" Range C17:C33 in another workbook.
Any help would be appreciated.
Sub VacationPayTransfer()
Dim wb1 As Workbook, wb2 As Workbook, i As Long
Set wb1 =...