auto - select, sort , save after paste

[k1dr0ck]

hi,

after a paste action in the sheet how do you?
auto select A1 up to the last row in column C with data
then auto sort the selection based on column A
then auto save

[kev_]

try this
- assumes that the correct workbook is active
- assumes that there are no empty cells in the relevant range in column A
- amend sheet name "MyData"

Please Login or Register  to view this content.

[kev_]

Lazy version of the same code

Please Login or Register  to view this content.

[k1dr0ck]

how do you trigger the macro select-sort-save after a paste action?

my list has no header should i just edit "Header:=xlYes" to "Header:=xlNo" ?

[kev_]

Add this line at the end of the Paste macro

Please Login or Register  to view this content.

my list has no header should i just edit "Header:=xlYes" to "Header:=xlNo" ?

YES

[k1dr0ck]

got it thanks!

[kev_]

You are welcome
Thanks for the rep