I use the following code to grab lines from employee timesheets and copy them into one master workbook. The first few columns sometimes don't contain data, but the forth column always does, so I use the xlDown and offset to find the range. Y5 is always the end of the copied range.
What I'm...