Hi all,
I am looking to make a rota for work and am having a bit of trouble duplicating worksheets identically.
With this I am meaning column/row width, boarders and also words/numbers.
I know it can be done as, well, Excel is magical, but also I have seen it done, but cannot work it out.
Also, as a sub question, the numbering in row A is representing the date.
Is there a formula and formatting option that allows me to have 1st, 2nd, 3rd, 4th etc. show with out having to type out across all the sheets (as I am looking to have this represent the whole year's rota).
I have added a picture to try and help explain any miscommunication.Rota.png
Bookmarks