Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update value of variable from one sheet to paste into another shee
Could somebody please tell me how to select a specific cell and store the
text string of the cell into a string variable. I then want to seach for the string on another sheet and paste into the cell on the RH side of the cell that was searched for. e.g Dim i As String ActiveSheet.Range("A1").Select i = ActiveCell.FormulaR1C1 ' search for i on another sheet. Sheets("Standards").Select Cells.Find (i) ActiveCell.Offset(0, 1).Select ActiveCell.FormulaR1C1=i Is this correct ? I'm pretty new at this and have had no training. Thanks for any help you can provide. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
look up data from a one w/sheet and take results to another w/shee | Excel Discussion (Misc queries) | |||
Auto input data on one sheet based on row selected in another shee | New Users to Excel | |||
Copy and paste cahrt to new sheet-update data automatically? | Charts and Charting in Excel | |||
How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) |