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 worksheet sheet will be referenced.
I have created a picture of what I would like the end result to look like without any code.. not sure how to load it here though..
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!
-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 worksheet sheet will be referenced.
I have created a picture of what I would like the end result to look like without any code.. not sure how to load it here though..
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!
