Thanks for your suggestion Paul. The purpose of the two forms was to save time during an external audit. The excel sheet would be passed on to the auditor with all the necessary data. But I suppose your other option would work too. I am new to macros but if you had a way to achieve this I am all ears/eyes. Cheers for the help.

Nick