I have a monthly report I have to produce for a director, it has sales data for certain products.
On my sheet I have several months to fill in and several different things to do but I want to try and make the whole process faster.
I have created the whole workbook to update figures when I insert the current report onto a selected tab, this of course filters the information and updates everything, however and this is where I need the help, on 10 pages all products need to be sorted into best sellers. I have multiple sections on one tab so for example:
Column A1:D18 will contain a list of products then F1:I29 will contain a list of different products.
Is there a code that can auto sort multiple ranges?
Thanks
Bookmarks