| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referring to a cell in another sheet
Hi. I need to have a formula in one sheet refer to a cell value in another
sheet. I would know how to do this if this was in the same sheet. How do I do this with respect to another sheet. For example, in the following command, I would like to refer to cells (i, 2) in Sheet 1 from the current sheet. Cells(lastrow2 + 1, 2) = Cells(i, 2) Thanks, Mike. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referring to a cell in another sheet
I think...
activesheet.cells(lastrow2+1,2).value = worksheets("sheet 1").cells(i,2).value Mike D. wrote: Hi. I need to have a formula in one sheet refer to a cell value in another sheet. I would know how to do this if this was in the same sheet. How do I do this with respect to another sheet. For example, in the following command, I would like to refer to cells (i, 2) in Sheet 1 from the current sheet. Cells(lastrow2 + 1, 2) = Cells(i, 2) Thanks, Mike. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referring to a cell in another sheet
Thanks, Dave!
"Dave Peterson" wrote: I think... activesheet.cells(lastrow2+1,2).value = worksheets("sheet 1").cells(i,2).value Mike D. wrote: Hi. I need to have a formula in one sheet refer to a cell value in another sheet. I would know how to do this if this was in the same sheet. How do I do this with respect to another sheet. For example, in the following command, I would like to refer to cells (i, 2) in Sheet 1 from the current sheet. Cells(lastrow2 + 1, 2) = Cells(i, 2) Thanks, Mike. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referring the cell instead of typing the sheet name | Excel Discussion (Misc queries) | |||
| putting date in a cell referring to the tab sheet | Excel Discussion (Misc queries) | |||
| Referring to a variable cell on another sheet | Excel Worksheet Functions | |||
| Formula referring to a different sheet | Excel Discussion (Misc queries) | |||
| referring to previous sheet | Excel Discussion (Misc queries) | |||
Linear Mode
