I used the "record macro" and went through my data manipulation steps.
But its not transferable to other worksheets because it imbedding the name of the worksheet in the some functions (sort, pivottable,...).
How can I change the name of the worksheet to "activeworksheet"?
Bookmarks