AndersNOR9
New Member
- Joined
- Nov 13, 2017
- Messages
- 20
Hi, I have an Excel workbook with a lot of sheets. The first sheet is an overview of revenues and other metrics for different firms for the years 2010 - 2016. All the other sheets are the financial statements for these firms. I have all the names for the firms in the A column and 2010 - 2016 in B, C, D, E, F, G, H, I. The names in column A corresponds to the names of each sheet. I want excel to get me the values I need for all the firms for all the years without having to do it manually. Any tips?
https://imgur.com/a/0iwatUJ
https://imgur.com/a/0iwatUJ