Is there anyone fluent in VBA here. I really need a help. I am comparing columns in two MS excel files but the number of rows in both of the files is different. I am trying to copy and paste the entries by calculating last non zero row but because by using [Workbooks(“GSP Appendix W 2018-05”).Worksheets(“RAP04 output file”).Cells(Rows.Count, 1).End(xlUp).Row
gives me the index of last row and that index is different in both files. so I am getting wrong results. I need a help here. Please anyone!!!