I have an Excel spreadsheet (attached) where I analyze the depreciation on houses that have sold in a suburb. Firstly I want other people I work with to be able to use it without being able to mistakenly change the formulas. In other words I want to protect it with a password. I would like a simpler entry page. Currently I enter the data into the suburb pages (tabs at the bottom) then have to copy and past into the subject page (tab at the bottom). Then sort them into order based on land size. I would like the process to be simpler with a macro to do the sorting automatically. Then I would like a macro that adjusts the print area so that it always prints a pdf to one page. I want it to look professional.
I need some one who can do macros and finish the job today . I would expect it to take about an hour for someone who knows what they are doing.