Quote:
Originally Posted by Spencer101
There are several ways of making this easier, but they depend on things like what version of Excel you're using for this workbook and what your data layout is like. None of which we can tell from your post...
|
Try the attached spreadsheet
The indirect function gathers text to make a formula - so you can specify in a formula what tab to look into. The other two tabs just format the inputs for the formula... if you require further explanation i can provide this.
Similar Threads
Threaded Mode
