VBA copy last row of non blank to another sheet

[phil133]

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!

 

[hiker95]

phil133,

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

I'm looking for a way that the last row in a sheet

3. What is the worksheet name?

is copied it in another sheet

4. What is the worksheet name?

Can it be done by a function or only by VBA?

By the way you have described your request, probably, by VBA.