Friday, 23 August 2019

vba - Excel - import data from cell automatically when a new tab is created

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

No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...