Excel: How do I link cells between worksheets?

[cpjust]

Hi,
I'm using Excel 2003, and I want to copy a range of cells from one worksheet into another worksheet. When I make a change to one of the cells in either worksheet, I want them both to be updated.

I was able to do almost what I want by doing a Paste Special and clicking the Link button. However, some of the cells which are empty in the original worksheet have a 0 in the new worksheet. I tried changing the "Format Cells" Category from General to Text, but it still displays a 0. How do I make empty cells be empty in both worksheets, but still be linked in case something gets typed into the cell in the future?

 

[xlhelp]

You will be able to Link (say) Sheet1 to Sheet2 but not the other way around. Basically, you can link one sheet to another. If you want both to change when one of the sheets is changed then you are looking at some serious macro.

If it's number formating that you have, there are two options you can follow.

The first one is the easiest. Go to Tools, View and uncheck Zero Values.

Or you can custom format the Cell (this you may need to practice until you get it right). The custom formatting follows a very simple rule, positive number, negative number and zeros. Once you have chosen Custom, in the TYPE box, you would choose a format for the positive number followed by a semi-colon, then the format for the negative number followed by a semi-colon. By leaving the format for Zero blank, you would get a blank cell.

Member- AAAA Association Against Acronym Abusers