Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yikes! Look ups? Match?
I have forty workbooks for individual surgeon , each contain the same data.
Each workbook has FYO6 total volumes, and each month of this FY. I need July and Aug totals from cell rangs AG4:AG31. I have a clickable sheet with all the workbooks listed in alpha order. And I think I can run something to get the months list on the sheets and the surgeons names in a cell as well...so I know what data belongs to who... Question is, how can I get the totals for the months of July and Aug with the names of the surgeons and month asssigned to each cell approbriately? Or is this all wishful thinking....a pipe dream...? Thanks so much for taking the time to read and for the help or intervention... :) -- Jules |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Index | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |