Transfering data from one worksheet to another Worksheet
 

I am trying to transfer data in certain cells on my first sheet(Proble
Sheet) to another sheet(Processed). It is processing ok but it is no
transfering the correct data.

The lines of code that are causing problems a

Sheets("Processed").Select
Application.Goto REFERENCE:=Range("END")
Selection.EntireRow.Insert
ActiveCell.FormulaR1C1 = "=Office Picked"
ActiveCell.Offset(0, 0).Formula = "Office"

It's working fine but it's not transfering the correct data. I wan
cell D5 on Sheet "Problem Sheet" to go where I have "office" in (0,0
specified. I can't seem to select the cell I want correctly.

Any ideas would be really appreciated. Thanks

--
Message posted from http://www.ExcelForum.com