Copying specific rows from an open workbook into the next row of a closed workbook.

Hi, I am new to this site and relatively new and self taught with VBA. I have a problem with some code where I am trying to copy certain rows of data (columns A:AG) from an open workbook, sheet name "HRIS FIN Sample File" (which will have daily variable length rows but with column data fixed) where a value in row CH = "Change" and append this to a closed workbook to the next free row of data on worksheet "HRIS Log". The closed file will be added to on a daily basis with all previous data added left intact for comment. I have tried the code below and it opens the specified destination file but it will only copy one line before it stops. I also want to save and close the destination file with the code but haven't got anywhere with this at all yet! Any assistance would be very much appreciated. I got the code online and moved the set DWS line as otherwise for each row, the macro tried to reopen the already open file? Thanks for any help!! Nigel.

Please Login or Register  to view this content.

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

You need to put the workbook and sheet name before this line

Please Login or Register  to view this content.

like maybe

Please Login or Register  to view this content.

You have marked this solved. Is it?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.