bloubul
Member
Hi All.
I got a workbook containing 16 different spreadsheets.
I want to know if 2 macro’s can be created to sort 11 spreadsheets up and down.
I’ve been on the Internet for days, but no luck.
The 11 spreadsheets are named as follows: 3 Draws, 4 Draws, 5 Draws, 6 Draws, 10 Draws, 17 Draws,
20 Draws, 35 Draws, 50 Draws, 75 Draws and 100 Draws.
It must sort all “Draws” according column “B” from the highest value to the lowest,
as values are allocated to column “B”. The sheets named “Draws” starts as follows.
1. 3 Draws starts in columns A6:B50
2. 4 & 5 Draws starts in columns A7:B51
3. 6 to 100 Draws starts in columns A8:B52.
Once that’s done and dusted the second macro must sort it back in column “A” as indicated back from 1 to 45, and “Clear” all values in column “B”
BlouBul
I got a workbook containing 16 different spreadsheets.
I want to know if 2 macro’s can be created to sort 11 spreadsheets up and down.
I’ve been on the Internet for days, but no luck.
The 11 spreadsheets are named as follows: 3 Draws, 4 Draws, 5 Draws, 6 Draws, 10 Draws, 17 Draws,
20 Draws, 35 Draws, 50 Draws, 75 Draws and 100 Draws.
It must sort all “Draws” according column “B” from the highest value to the lowest,
as values are allocated to column “B”. The sheets named “Draws” starts as follows.
1. 3 Draws starts in columns A6:B50
2. 4 & 5 Draws starts in columns A7:B51
3. 6 to 100 Draws starts in columns A8:B52.
Once that’s done and dusted the second macro must sort it back in column “A” as indicated back from 1 to 45, and “Clear” all values in column “B”
BlouBul