Sort macro conflicting with formula to produce incorrect results

Pretty sheet BUT ...

Creating multiple sheets and then trying to link them in this way is always a Royal PitA and best avoided.

I'm afraid I can't give you a solution as I probably wouldn't start from this position. IMO you would be best redesigning the workbook/worksheets. You're using Excel 2010 so you have 16384 columns available to you. My approach would be to have column A as the employee name and then have 355/366 columns for the dates of the year from 1 January through to December 31, perhaps with a blank column between each month. You could use the blank column to group the days of each month. This would allow you to have the current month visible for input and/or printing. You could, perhaps, have a macro to select and print a specific month, hiding columns not required.

You could then have the month totals on a separate worksheet with a set of columns per individual with the annual totals at the end.

In this way, you would only have two sheets and it would be simpler to insert rows and align the data. On the Totals sheet, instead of using a simple =Jan!A5, you would be better having a column which uses MATCH to identify the row for each individual and then using that in SUMIFS/INDEX formula ... not worked that out in my head but doable.

Hope this helps ... or, at least, provides food for thought.


Regards, TMS

Thanks for the rep.

You're welcome. Thanks for the feedback.