|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#8
04-24-2017, 05:06 AM
|
|||
|
|||
You're a genius! I've been trying to get the suggestion from ExcelForm to work all evening and it just hasn't been working.
Ok so this is an example of one of the formulas: =MAX((INDEX(FlakeLength,$AH2-1):INDEX(FlakeLength,$AI2-1))) I noticed that you have split the data range info in my spreadsheet into two columns, and I see how that plugs into the above formula, but how does the formula know that this data range info relates to the 'Master Data' tab? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to automatically insert a line after a Column Break | YooperNC | Word | 3 | 01-29-2015 07:16 AM |
| Auto Generate Invoice Number Word 2013 | Jonah245 | Word VBA | 3 | 09-04-2014 05:24 PM |
 Automatically generate PDF from saved word doc
|
JamesHusband | Word | 3 | 06-07-2014 08:30 AM |
| Randomly generate numbers, Macro? | Jamtart | PowerPoint | 30 | 08-15-2012 10:55 AM |
| Can I auto increase numbers in a column? | compact | Word | 1 | 09-10-2009 07:16 AM |
Windows XP 
Office 2007
Threaded Mode