Hi again.

With all the help you guys have given me my spreadsheet is nearly complete. Hopefully last problem - Basically i now have one sheet (the input sheet) where i enter transport data and this populates despatch notices on 7 other sheets (one for each day of the week). On the input sheet i have hyperlinks to each respective despatch notice.

The problem is i now want to copy these 8 sheets 52 times to make up the whole year. I copied the 8 sheets once and noticed a problem. The hyperlinks still link back to the original input sheet and despatch notices as opposed to the copied input sheet and despatch notices. Is there a way around this or will i have to relink all my hyperlinks.

Im hoping this is clear enough for you guys to respond as there is sensitive info on the spreadsheet so would prefer not to have to post on here.

Thanks in advance