Hi experts!
I have a master workbook that pulls data from other workbooks and sometimes entire tables are brought over using simple cell linking. Now I want to have a button that allows sorting alphabetically the values in the original workbook so they will show up sorted in the current one that has all the links.
This is needed because the source workbooks will continuously have need data added to them and need to be sorted but I don't want to go and open each one to do this each time.
Any help is appreciated!