I need a way of automatically copying the same data from one worksheet to a second worksheet without typing it out again. The only problem is this data should only be copied when a value is entered in a certain cell.
I have an excel layout whereby on my first worksheet my 'A' column is initially empty, the 'B' and 'C' column is filled with data.
I'm looking for a formula which, when I enter any text in column 'A' on a certain row, the contents of Columns B and C on that row are automatically input on a second worksheet in a certain place.
i.e.
If (A1 = text/number/value) then ('worksheet2' B1 and C1 = 'worksheet1' B1 and C1.
Anyone got any ideas?
I have an excel layout whereby on my first worksheet my 'A' column is initially empty, the 'B' and 'C' column is filled with data.
I'm looking for a formula which, when I enter any text in column 'A' on a certain row, the contents of Columns B and C on that row are automatically input on a second worksheet in a certain place.
i.e.
If (A1 = text/number/value) then ('worksheet2' B1 and C1 = 'worksheet1' B1 and C1.
Anyone got any ideas?