cop[y and paste script?

[Djwbaker]

Hi, used automate for power bi, but now trying to replace some of my VBA in excel for a less manual process
i have a simple vba that copys table finds last row and pastes values. can you do that with a script?
cheers Dan
or tell a script to tun a macro?