-
VBA get the Max and adjacent value from each column per worksheet
Good Afternoon.
I'm trying to create a code that displays the maximum value from column A and it's adjacent value from column B, from each worksheet.
I have sheet1 as my collection sheet. All the other sheets are named referenced to it's file name.
I would like the code to be able to collect the data from each tab and display the values in a list on sheet1.
Any help would be much appreciated.
Regards
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules