Hello all,
I am very new to excel and am just getting into the world of VBA but find myself very lost. I am trying to find code that can sort data across multiple sheets, but only when there is data present.
On the first sheet I am trying to sort everything in column D from highest to lowest
On the sheet 2-6 I am trying to sort everything in column B from highest to lowest
The kicker is that every week I will need to delete data from each sheet and paste new data in its place. I was able to find some code on how to sort but when I tried to clear the data out from one sheet everything crashed
I also plan on making a button that can clear out all the data from each sheet, to make it easier to paste in the new data each week
Any info is helpful, thanks!