I'm a complete novice at VBA. I need a macro to copy a range called "trackerinfo" in an active workbook and paste -special values to the first empty row in a worksheet in another workbook.
The other work book is located "L:\Customization\QUALITY\CN's & CAR's\CN Tracker\CN Tracker 2015 - robin.xlsx"
The worksheet that I want to copy the range into would be active once the file is open - the sheet is called "CN Tracker"
The list I want to find the empty row to paste the range into starts in cell A3 (header line) - first row of actual data is cell A4. Just a heads up that this list already has about 10 rows of data. I need to paste special - values into the first empty row at the bottom of this list.
If it's not too complicated I'd like this macro to work without having the second workbook open - but if this is too complicated I can have both workbooks open before the macro is run.