Importing first/last row and last column from excel file.

Question

Hi all,

How can I dynamically select the cells between Series and before Total  (A9:A89) ?

Also how can I select last column? Ie A9 : LastColumn89? which would be A9 : Y89

wonka1234 · Answer

@oly

Still have some issues here, getting all 0's in my select column!

oly · Answer

You are correct, just the "SERIES" column should work! Make sure it's exact spelling and you can double click on your column by expanding Row-1 in "Variables" options and others. Currently I believe it's just a variable spelling typo that the tool doesn't like. Also, make sure there's no iddle spaces in the variable name. Again, easiest way it to double click on your columns.

wonka1234 · Answer

@oly

you mean something like this ? or do all my columns have go in in here?