G
gport
I have two worksheets with name, address, etc. I am trying to transfer data from one to the other so that I only type the info one time and it puts it in all other worksheets. I clicked in the cell I wanted the info to duplicate in and I type + then clicked on the worksheet and cell I wanted and hit enter. The problem is that in the worksheet that I want the info to duplicate in, it shows the formula not the information I wanted there. I have done this through the whole worksheet and all is fine except this one cell. It is the Zip Code and it will not display the text only the formula. Help!!