![]() ![]() Most beginner Excel users don’t think like this, so there is a good chance you’ll come across these types of workbooks and will need to use this technique at some point. As you’ll see in our example files, the January, February and March are the same type of data in the same structure, so they should really be in one table on one tab. If there is one Excel best practice which users ignore all the time it’s this – keep data of the same type on one tab. ![]() But what if we want to import ALL the data within the same workbook? Well, that is where we are headed in this post. We’ve seen how to import external data from a single file, how to import all the files in a folder and how to import data from a Table / named range within the same workbook. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |