I am using a workbook and have two worksheets that need to be identical with the only difference being, how a persons daily fee is shown. In Worksheet 1, it is shown as #days and in Worksheet 2 it is shown as the # of hours. Otherwise everything else in this 5 page bid is identical between the two worksheets.

I Made a copy of Worksheet 1. and called it Worksheet 2. I'm going into each cell (for example in Worksheet 2 cell 31, I would type: ='Worksheet1'!N31. This way as a person uses the 1st worksheet, all the same information is going into the 2nd worksheet.

I am having trouble with two Textboxes though. I cannot see how to use my method above to have the information in the text boxes carry over. There is no way to type the formula to refer to the 1st Worksheet. These text boxes have all the project notes on them and as a person fills those out on Worksheet 1, I need the same information on Worksheet 2.

I am not familiar with macros yet. so hopefully there is a way to accomplish this.

I am using Excel 2008 in compatibility mode because no one I know has the latest version.

Thank you for any help attempts.