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.

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

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