Transfering data from another Worksheet

  • Thread starter Thread starter sryan
  • Start date Start date
S

sryan

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

The lines of code that are causing problems are:

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 want
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.
 
It's not clear what you want to do. This particularly is confusing:

ActiveCell.FormulaR1C1 = "=Office Picked"
ActiveCell.Offset(0, 0).Formula = "Office"

It puts the formula =Office Picked in the active cell, and then immediately
overwrites it with the text "Office". Also, since the name "Office Picked"
is not a valid defined named it's not clear whether you're making a mistake
or doing some sophisticated intersection operator work. Maybe you could
clarify what you want to do.

Btw, just to help you with the terminology, "transferring data" is usually
taken to mean a Cut and Paste. What you're doing I think is writing
formulas to "reference" data in other cells. Just FYI.
 
I got it working. Thanks for your help. I had to name the cells on the
first sheet (ProblemPage)
 
Back
Top