Min Function across multiple worksheet and associated worksheet title for clarification

**VBAISGR8** · 10-30-2018, 11:27 PM

Hello All,

So i'm inputting statistical information for my fantasy football team to gain an edge on my defensive team since i couldn't snag one of the top defenses. ESPN has great statistical data that I've inputted into a workbook in excel. So now what i'm trying to do is organize the information to be useful.

Goal: =min('Tennessee Titan Defense:Carolina Panthers Defense'!B4) ****PLUS**** I want to pull the team name in a cell next to it or within the same cell to clarify which team has the min

EXAMPLE: Carolina Panthers Defense: 121

It doesn't have to fit specifically the format above but would like to pull the worksheet name in along with the information or else it's useless, I could go through find the min by hand and type it into another workbook.

Let me know if that makes sense and if you have a fix for this!

No rush, this is only due by Thursday as that's when the game is!

**alansidman** · 10-31-2018, 12:44 AM

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**VBAISGR8** · 10-31-2018, 12:49 AM

Hello,

Thank you for the clarification, I was just thinking about how people would understand what I'm talking about without any reference...

Let me know if this attachment worked and if it is in the proper format for people to undersatnd.

Thank you

**alansidman** · 10-31-2018, 01:05 AM

Here is a VBA solution:

Please Login or Register  to view this content.

How to install your new code

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

Press Alt-F8 to open the macro list
Select a macro in the list
Click the Run button

Min Function across multiple worksheet and associated worksheet title for clarification

LinkBack

Thread Tools

Rate This Thread

Display

Min Function across multiple worksheet and associated worksheet title for clarification

Re: Min Function across multiple worksheet and associated worksheet title for clarificatio

Re: Min Function across multiple worksheet and associated worksheet title for clarificatio

Re: Min Function across multiple worksheet and associated worksheet title for clarificatio

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Worksheet has multiple columns with same header title, need to consilidate into one

[SOLVED] Forum Guru Title Calculation Method Clarification

[SOLVED] Macro or Function to add a title (ie Exhibit 1) based on worksheet index to muliple sheets

Worksheet title

Link a worksheet title to a cell in the worksheet

[SOLVED] Link title of worksheet to whatever the worksheet tab is named

[SOLVED] Reference the worksheet from a multiple worksheet range function (

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions