Apache OpenOffice Community Forum

I have a three sheet spreadsheet application and need to copy text entered in column A on Sheet1, to the same positions on Sheet2 and Sheet3.

For example, Sheet1 column A is a text column where I enter the names of students. Columns B-L contain numeric data for each student.
If I add a new student name to the foot of the name listing in Sheet1: column A, I would like it to be added to the student column A list on Sheets 2 & 3.

Is there a function for handling the copying of text between sheets?
Thanks for any help.
Dave

The easiest way to do this is to enter a formula in column A of Sheet2 and Sheet3. In A2, the formula would be You can then copy that down as far as you like. It will show a blank cell until the corresponding cell on Sheet1 is filled.

Formulas cannot push information into another cell. A macro could be written to push information from Sheet1 to the other sheets but writing that would take you far longer than hand copying the data and the formula above is even quicker.

Hello FJCC,
A double thank you. The "Sheet1.A2" approach works perfectly.
And thank you for your fast response.
Both very much appreciated.
Dave