Min and Max Values on Separate Tab

RandyD123

Active Member
Joined
Dec 4, 2013
Messages
289
Office Version
  1. 2016
Platform
  1. Windows
I have a multi-tab spreadsheet that I want to extract the MIN and MAX values from the monthly tabs and transfer them to my "FL" tab. The code I use now does not allow for me to just drag the top value down to fill in all the cells in the columns. I think that "INDIRECT" might be what I'm looking for but not sure how to write it. Sheet can be seen here

Any help would be much appreciated. Thank you.
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
I think nobody want to play with passworded workbook but maybe... who knows :), the removal of the password took only 5 seconds.

Have a nice day
 
Last edited:
Upvote 0
thought I removed all of that....I will edit it and remove password
 
Upvote 0
Unprotected File is HERE Sorry for anyone that tried to help. Thought I removed all the VBA!!!
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top