willdow999
New Member
- Joined
- Sep 30, 2019
- Messages
- 3
Hello All,
I have a large accounting file with parallel construction which I need to pull into each of my assets Profit and Loss Statments. Each asset has a separate PnL page, and in my accounting worksheet, I have each asset named seperately.
I'd like to create a formula where I type in the sheet name, and cell reference number, and my fund model pulls in in the value from the EXTERNAL workbook. I believe this can be accomplished by INDIRECT? Thank you very much!
I have a large accounting file with parallel construction which I need to pull into each of my assets Profit and Loss Statments. Each asset has a separate PnL page, and in my accounting worksheet, I have each asset named seperately.
I'd like to create a formula where I type in the sheet name, and cell reference number, and my fund model pulls in in the value from the EXTERNAL workbook. I believe this can be accomplished by INDIRECT? Thank you very much!
