Transfering data from one worksheet to another Worksheet

S

sryan

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 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 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Copy Data from one worksheet to another 1
Lookup Cell Interior 1
Cell Toolbar Dilemma xl2013 13
Create if partial match then copy and paste data from one cell to another 1
Search , then copy and paste from multiple worksheets. VBA help 1
Macro to Combine Data from Multiple Sheets with Cell References 4
setting one worksheet cell range reference to another worksheet 1
Transferring data between worksheets? 8

Top