I have retrofitted the attached to remove any identifying or sensitive data. It represents the report workbook I am trying to construct. The tab "compendium" is from a data link to another workbook I cannot afford to mess up. On Sheet 5 you will see in B2 where I try to import data from Compendium sheet based on a cell value "Jane Doe". I will expand the formula to include columns A,B and D when I am done. This formula has worked for me in the past with a little bit of tweaking, but today it will not work at all. In fact, when I click Cntrl, Shift, Enter I get a file selection box. I think the fact that I am trying to glean information off of a data connected table I need to do something else, but I need to ask you all if that is right. My end goal:
Use the information on the data connected table (Compendium tab) to create seperate reports based on the contents of col F. These reports will include the data in col A,B,D, and F
forum report.xlsx
Bookmarks