Need help to create an automated summary workbook from separate workbook with variable sheets
Essentially what I am looking to figure out in excel 2010:
-2 separate workbooks (1 full of data, other is a summary workbook)
-Need the summary workbook to create a row for every sheet in data workbook (data workbook can have anywhere from 1-? sheets- starts with minimum 1, and then sheets will be added throughout the year, sheet names will also be variable)
-In each new row, 3 cells from the data workbook sheet will be referenced.
I have created a picture of what I would like the end result to look like without any code.
I know how to reference the cells from separate workbooks, but do not want to have to manually link the files every time a new sheet is added to the data workbook.
I also have very basic knowledge of VBA so please be patient!
Thanks!
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago