Prev: Removing or deleting Checkboxes from workbook
Next: .value
From: Becky on 14 May 2010 15:17
I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I want
"Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How?
Thanx
From: Rick Rothstein on 14 May 2010 15:28
Something like this I would guess...

With Worksheets("Sheet1")
If .Range("B7") = "certain word" Then
Worksheets("Sheet2").Range("B2").Value = .Range("B8").Value
End If
End With

--
Rick (MVP - Excel)



"Becky" <Becky(a)discussions.microsoft.com> wrote in message
news:F7422B7D-BF3F-4B12-9790-FCA111E960EA(a)microsoft.com...
> I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I
> want
> "Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How?
> Thanx

From: DB on 14 May 2010 15:45
How about:
=IF(Sheet1!B7="certain",Sheet1!B8,"wrong word")

"Becky" wrote:

> I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I want
> "Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How?
> Thanx
From: Dave Peterson on 14 May 2010 16:19
Check your other post.

On 05/14/2010 14:17, Becky wrote:
> I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I want
> "Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How?
> Thanx
 | 
Pages: 1
Prev: Removing or deleting Checkboxes from workbook
Next: .value