Hi guys,

This is for an income statement of several businesses, and I have cells that look basically like this: "business1.xslx field 1" + "business1.xslx field 1" + "business1.xslx field 1" etc. with each value corresponding to one of the businesses. A summation of values from different files.

I want to do the income statement per business, without having to redo everything. Is it possible to extract the value for each individual business for each cell from the summed up income statement? E.g. business 1 would just have "business1.xslx field XYZ" etc.

Each value in the summation is identifiable because the filename corresponds to the business, so if I can somehow search or match for business XYZ inside the formula, and extract that value, that would do the trick.. but that's just a concept. I am not an Excel expert.

Thanks so much