Naming Ranges in Excel

3.53K viewsDataLink

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!


Ok, one solution that I found is to control click each worksheet, and then apply the names. However, is there a better solution native to Quantrix? Thanks.

You are viewing 1 out of 4 answers, click here to view all answers.