| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transfering a figure from 1 worksheet to the next | Excel Worksheet Functions | |||
| Transfering of data from 1 worksheet to another | Excel Discussion (Misc queries) | |||
| Transfering data from worksheet to another | Excel Discussion (Misc queries) | |||
| Transfering a row of data to a template word or worksheet | Excel Discussion (Misc queries) | |||
| Transfering data from 1 worksheet to another | Excel Discussion (Misc queries) | |||
Hybrid Mode
