Hello i am new to the forum world so please bare with me.
I have been creating Macro's to simplify tasks, my main source of creation has been by recording Macros which has done its far share of help. But I finally have hit a bit of a road block here when trying to record a macro selecting a certain area and then sorting it via the custom sort option under "sort & Filter"... I am sorting with three levels selected.. and am trying to have the Macro create these new levels and run on any new workbook not just a specified work book name which is were my issue comes in, every time I record I get it stated to work with "ActiveWorkbook.Worksheets("sheet1")" which provides an issue as you can imagine because the other work books names are not the same.
here is the Code i want to run on any workbook i open and run it on. is there an alternative to "Activeworkbook.worksheets("")?
Thank you !
Bookmarks