Good Monday morning to you!
Is there a way to make it so an XLSX will pull data/reference a CSV file in the same folder? Right now I'm simply opening both files, copying the CSV and pasting the data into a tab in the XLSX. I was wondering if there was a way to eliminate the need for the copy and paste, if the CSV (since it's the only one of that format in the file) could have the data retrieved from it another way. Am I out of my mind thinking this can be done? That maybe I just need to wait for my coffee to kick in before I start asking questions...?
Regards,
Nanaia
"Do or do not, there is no try"~Yoda
Is there a way to make it so an XLSX will pull data/reference a CSV file in the same folder? Right now I'm simply opening both files, copying the CSV and pasting the data into a tab in the XLSX. I was wondering if there was a way to eliminate the need for the copy and paste, if the CSV (since it's the only one of that format in the file) could have the data retrieved from it another way. Am I out of my mind thinking this can be done? That maybe I just need to wait for my coffee to kick in before I start asking questions...?
Regards,
Nanaia
"Do or do not, there is no try"~Yoda