Copy and paste to another workbook if specific criteria is met VBA

I am trying to create VBA code which copies rows from one workbook (Test Report.xlsx) and then pastes that copied row into another workbook(Test Final Report.xlsx), if it meets specific criteria when the commandbutton is clicked. The criteria to copy and paste is a if a cell in the second column in the table contains the critera 3'5, copy that row and then paste it into another workbook. I've tried the following but when I go to run, it just selects cells specified in the line of code before End Sub. I need assistance with this, please see below the code which keeps failing me. What am I doing wrong and what should I do to make it right?

Please Login or Register  to view this content.

You mention two worksheets, ("3.5" and "Sheet2"). This is a little confusing. What is the name of the worksheet in Test Final Report.xlsx where you want to paste the copied rows? Where in that destination worksheet do you want to paste those rows?

Apologies, see the code here which is giving me problems:

Please Login or Register  to view this content.

Place this macro in the Test Report.xlsx workbook and save the workbook as a macro-enabled file. The macro assumes you have headers in the first row of sheets("Mar'19") and that there are no blank rows in your data. It also assumes that both workbooks are open.

Please Login or Register  to view this content.

Hi numberonelevelit and Welcome to the forum,

Administrative Note:

Please use code tags when posting code. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window.

More information about these and other tags can be found here

Which line of code is highlighted when you click "Debug"? Can you attach copies of your two files (de-sensitized if necessary)? It would make it easier to test possible solutions.

The headers is the sheet "Mar'19" in row 7 are totally different from the headers in row 10 of the sheet "3.5". They also have a different number of columns. When copying the rows from "Mar'19" to "3.5" I don't know into which columns to paste the data. For example, sheet "3.5" has these four headers: UBA, EURO, CHEQUE BOOK NO. and PETTY CASH but there are no corresponding headers in "Mar'19". Please clarify in detail referring to specific columns, what data you want to copy from "Mar'19" and exactly into which columns in "3.5" you want to paste that data.

Try:

Please Login or Register  to view this content.

Make sure that there are always 2 blank rows above the "TOTAL" row in "3.5" sheet.

You are very welcome.

According to Forum rules, you should not post your question in another member's thread. Please start your own new thread and inlcude a link to this thread if you think it is useful. If you send me a private message with a link to your thread, I will be happy tp have a look at it.
Your link doesn't work. Please see the yellow banner at the top of this page for instructions on how to attach a file.