I am working on a spreadsheet summarizing data from standard templates inserted in a joint Excel file as separate tabs.
Is it possible to automatically import data from a specified cell into a summary tab, when a new tab is created? Since the data I want to extract is in the same cell in each document, this would save me a lot of time and effort
Best Answer
Something like this will create a list in sheet1 column A of Sheet Names, and every time cell
C1
on any sheet changes, it will place the value of that cell into sheet1 in column B, next to the corresponding sheet name in column AIt goes in the
ThisWorkbook
module through the VBA editor*. You can change the sheet name and ranges as needed.*To get to the VBA editor, you must go to the office button, excel options and in the popular tag, place a checkmark in the box next to
Show Developer tab in the Ribbon
. Then close that out, go to the developer tab and click theVisual Basic
button on the far left. The editor will open up and you will need to double click theThisWorkbook
module on the left pane.