Solve : excel 2003?

1.	Solve : excel 2003?
Answer» I have the same PERSONS name on different worksheets. What I want to do is when I enter data next to that person on the first work SHEET, I want to automatically be copied onto ther other worksheets of the person with the same name. I hope this is clear.All all the sheets in the same book? Have you looked at the on-line documentation about worksheet inks? http://office.microsoft.com/en-us/excel-help/create-a-link-to-another-cell-workbook-or-program-HP005199514.aspx It is in the same work book. I checked the link. I must have overlooked it. It SUGGESTS something about link cells.Quote from: leonardharrietha on October 16, 2011, 09:52:50 AM ... I want to automatically be copied onto ther other worksheets of the person with the same name. I hope this is clear. Do the cells in the other sheets with person names remain in a constant location in those sheets?yesSee http://vitamincm.com/excel-link-cells-tutorial/. I think it will be more helpful than the reference previously posted.

Answer»

I have the same PERSONS name on different worksheets. What I want to do is when I enter data next to that person on the first work SHEET, I want to automatically be copied onto ther other worksheets of the person with the same name. I hope this is clear.All all the sheets in the same book?
Have you looked at the on-line documentation about worksheet inks?

http://office.microsoft.com/en-us/excel-help/create-a-link-to-another-cell-workbook-or-program-HP005199514.aspx
It is in the same work book. I checked the link. I must have overlooked it. It SUGGESTS something about link cells.Quote from: leonardharrietha on October 16, 2011, 09:52:50 AM

... I want to automatically be copied onto ther other worksheets of the person with the same name. I hope this is clear.

Do the cells in the other sheets with person names remain in a constant location in those sheets?yesSee http://vitamincm.com/excel-link-cells-tutorial/. I think it will be more helpful than the reference previously posted.

Solve : excel 2003?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment