Hi!

I was wondering if there was a way select pre-entered data in a table. In the spreadsheet, I have three 'Stations' each with their own unique co-ordinates but for each different scenario, I have to change around their relative position and I'm sure there must be a better way than messing around with copy and paste. I have tried using tables, but they always seem to switch around he vertical columns not the rows which I need. If anyone could point me in the right direction that would be great !

Many thanks,

Charlie



Energy Calculator.xlsx