excel vba - Copying specific range of data from one workbook to another -

I am trying to copy data from a workbook and paste it into another. I want to copy it to a specific category, which is the last cell that contains the data.

This is what I have so far but it provides an error for me to subscribe to 'outside the category'.

sub-ballog () with workbook ("backlog query ahsi") Work sheet ("Sheet 1") lastRow = .Renz ("A" and .ROCount). End (XLEEP). Row and End Worksheets ("Data") with this workbook. Range ("A2: A" and last time). Value = workbooks ("backlog query ahsi"). Work sheet ("sheet 1"). Category ("A2: A" and Last Row) Version ("Sheet 1"). Version ("M2: AH" and "Last"). Price = Workbooks ("X2: X" and the previous row ("L2: L" and the last line). Version ("Backlog query AHSI"). Backlog query AHSI "). Work sheet (" Sheet1 "). Category (" L2: AG "& LastRow). Value and Sub

Copy class = "post-text" itemprop = "text">

You only need to specify a single cell for the destination:

< Pre> workbook ("order Query AHSI "). Worksheets (" Sheet 1 "). Click on Range (" A2: A "&" A ")