Sorting list in another workbook via button in the first


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!



Where is your question? Here @TeachExcel, we like to have questions the answers to which can benefit the wider community. To ask such a question you might have to actually start encoding your idea. You may be surprised how far you can get before you hit the fri\\irst snag, the first real question.
Variatus (rep: 823) Aug 15, '17 at 2:43 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login