Last Row not being identified correctly

The following macro works great if I run it the way it is intended to be run which is workbook "XXX XXXX Master Workbook.xlsm" contains this macro and a sheet called "Dump"

Every Monday i get a spreadsheet called ABC.

I run this macro and it presents me with the data that I can work with.

I cannot combine multiple weeks of data on one Dump sheet because this macro keeps referencing and in turn overwriting the existing data.

I tries to create a new last row code to replace the specific start point of F2 but I think it is great than that.

Hopefully someone can provide me with the correct lines of code without requiring a sample since this code references at least one other workbook that I wouldn't be able to post, at least publicly.

Please Login or Register  to view this content.

Dave,

Thanks for the reply.

I believe I made an error in my first post by only identifying one Last Row which is why this still is not doing what I need it to do. I made some notes within the code below.

Please Login or Register  to view this content.