Hello!
Attached is an excel sheet. "data" is a data import in .txt format.
Each sheet corresponds to one month. If I want to plot something over a year with this info, i need to import 12 of these sheets. I'm trying to figure out whether it is possible to "automate" the input of this data onto a table like in the "table" sheet. My objective is that someone can just copy paste into this excel sheet and be done with it. Is it possible?
Is it possible to "look for a specific sheet" in the workbook, based on its name AND have sheet names change according to a date input?
Don't bother trying to make a formula just yet. I'm just trying to understand what are my options for this first. Hopefully you guys can give some ideas and clear some doubts.
Thanks in advance.
Bookmarks