I have attached a sheet with a basic example of my prob
I have multiple sheets with formula references that refer to other sheets.
My data is constantly growing so I need to add people "teresa green" in example, who owes me £50 according to 'accounts' sheet
but I want my people in alphabetical order, if you try and sort the names into alphabetical order then it messus up the data and now shows Teresa Green owing £20 which is wrong.
I really need help finding a solution to this. I cant just insert a row into the sheets because this will mess up my "thick black line every two row" formatting, particularly as I will be adding a lot of people. This formatting is very important to my actual workbook (if not to this one)
can anyone help?
I will be very grateful