Macro to define names for multiple ranges

Hi guys,

I hope one of you gents can help me with the following issue.

I am trying to create a macro that would define names for each column in the attached sheet. I wanted the range's name to be the value in the first row and the range to be the last 90 values in the column. Right now I have three sets of data, but I would add more.Example00.xlsx

Thanks in advance!!

Hi, thanks for your quick reply.
However, that is not exactly what I am looking for, perhaps I wasn't 100% clear - pls excuse my english.

I wanted a range for each column, refering to the last 90 entries, named after the first cell in the column. For example (in the example workbook), a range called Data1 for A166:1255, a range called ITSA4 for B166:B255, and so on.

Thanks again!

Thanks a lot, JieJenn, it does work well.

To make it even better, is there a way to modify the formula so it would always get the last 90 entries, even after I add more? Something like offset.

Thanks again!

Yeah, I had not noticed it before. Thanks again!