GeorgeRemias
New Member
- Joined
- Apr 10, 2002
- Messages
- 2
I have several workbooks with exactly the same format but different data. I want to extract a porton of the data (always the same tab and cell address) from each workbook. Anyone know how to write a formula that does this? I tried populating a column with the workbook names and then concatenating that with text within an Indirect formula, but only get volatile results. Does not help to try an array formula, either.