Linking between worksheets in the same document

[jay72877]

Can someone give me some pointers on this Excel question when it comes to linking data between worksheets in the same document?

I have an Excel 2003 workbook with three worksheets. I want my users to be able to insert information in two of the worksheets. My question is: is it possible to have the text that is inserted in the two worksheets automatically populate the third worksheet. I don't want my users to have to input the information two times.

I know I can hit = then click on the cell and the contents in the cell will appear in the other worksheet. But my worksheets contains several columns where information can be entered. If a user inserts information on the same line and several columns, can all of this text populate the other worksheet? I imagine there is some VB coding that will take place.

Any information would be great, thanks! -Jason

[mrice]

Can you attach an example showing the input on the first two sheets and the desired outcome on the third. It's not obvious from your question as to what the third sheet might look like in relation to the other two.

Some VB code driven from the worksheet_change event would be an obvious way of tackling this one.