BRSebbe

Thank you! Will play around with that

That seems to have done the trick for the Y origing Although i messed up the formula or it was wrong as i am getting this! KR Sebbe

Fine suggestions all of it, although not quite what im after! I've gotten closer to the goal, now i just need help to figure out how to sort these 3 columns the way i want. So i want column "C" To display only -X numbers Column "D" to go from positive 420 to 0 to -420 And column "E" To display only positive numbers i've manually created a non working example, see attached image #2

So I've gotten this far, the issue i have now is how to properly sort it the way i want to. That being i want it to sort on the "Origin Y" But to sort it as + or - so that every - is on one half and all the + is on the other half, as you go about chalking it out.

Hello As im not really used to working with worksheets/excel in general i now turn to the community. I am trying to make a worksheet template for hoists, to make an automatic X/Y list for sending out to riggers onsite. The idea im trying to make happen is that once imported into the current document im working on it displays the hoists i put in the drawing, sorted on +-/XY, and also if i delete a hoist it will also disappear from there Any help or pointers as to how to get there, or if my idea just isnt doable would be much appreciated! Kind Regards Sebbe

Ah, that does it. Thank you.

Has there been a recent update that removes this way of doing it? I work with several different suppliers, all of whom have different hoists and lengths of chain, im trying to find a quick way to either make symbols for each company, or make some attachable records to use. The way discussed here seems good, although i cannot seem to be able to do it! When i right click a symbol in the resource manager all i get is this