calculate one column move info from another

[wafs]

is it possible to have an if statement look at one column and have another column move to a new worksheet???

 

[SkipVought]

Hi,

if cellobject.value = somevalue then
  someothercolumnobject.copy othersheet.othercellobject
end if

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
Poultry in motion to pullet for a paltry amount!}

 

[wafs]

Thanks Skip it works, but now I need to add an add to that if. When I add the and to the if statement, it goes directly to end if and ends. HELP!!

Here is the code.
i = cellstart
TestRange = "AF" + i 'over 30 days column
TestRange2 = "AE" + i 'future 6 wks production column
TestRange3 = "A" + i 'part number column

If Sheets(sh).Range(TestRange) > 60 And Sheets(sh).Range(TestRange2) <> 0 Then

 

[SkipVought]

You apparently do not meet the criteria that you set.

What is the value of Sheets(sh).Range(TestRange)?

What is the value of Sheets(sh).Range(TestRange2)?


Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}