P phil133 Active Member Joined May 5, 2015 Messages 257 Office Version 365 Platform Windows May 25, 2015 #1 Hi. I'm looking for a way that the last row in a sheet is copied it in another sheet. By last row I mean the last row that column A is not blank. Can it be done by a function or only by VBA? Thanks for any help!