Ok, I have a spreadsheet with 12 worksheet, each with 5 columns. In order for Quantrix to see the columns, I understand that I need to name each range. But that is a lot of typing (60 columns).
Is there a way to have Quantrix just read the name of the columns in the Excel spreadsheet? Or is there another way to automate this?
My tired fingers will thank you for any suggestions!
I don’t have any specific feedback on maintaining index’s between excel ranges – outside of the fact that it might be problematic. My inclination is that it sounds like you are in a need of converting these multiple spreadsheets into a database?
Maybe someone else out there has more experience than I in this Excel realm…?