the data is entry and exit points, as far as the range thats the probloem the range length varies and i need to make the max floating to those various ranges. I have 10 spreadsheets of 25000 lines with hundred of entry and exit points in each spreadsheet and dont want to do this manually