We have developed a listing of inventory items with a cell associated with
each item that indicates if it is present. Is it possible to have the items
not present to be exported or listed on a different form or worksheet.

On Mar 24, 3:15*pm, Jeff Frazier <Jeff
Fraz...@discussions.microsoft.com> wrote:
> We have developed a listing of inventory items with a cell associated with
> each item that indicates if it is present. *Is it possible to have the items
> not present to be exported or listed on a different form or worksheet.

Yes, you can do something like this

Sub MOVETHEM()
Dim CELL As Range
For Each CELL In Range("B1:B50")
If CELL.Value = "NOT PRESENT" Then
CELL.EntireRow.Copy
Worksheets("Sheet2").Rows("65536").End(xlUp).Offset(1, 0)
End If
Next CELL
End Sub

I used range ("B1:B50") as the column that identfies if it's "PRESENT"
or "NOT PRESENT"

At the risk of sounding under-informed, can you point me in the direction as
to where that would be entered?

"Jeff Frazier" wrote:

> We have developed a listing of inventory items with a cell associated with
> each item that indicates if it is present. Is it possible to have the items
> not present to be exported or listed on a different form or worksheet.

On Mar 24, 5:01*pm, Jeff Frazier
<JeffFraz...@discussions.microsoft.com> wrote:
> At the risk of sounding under-informed, can you point me in the direction as
> to where that would be entered?
>
>
>
> "Jeff Frazier" wrote:
> > We have developed a listing of inventory items with a cell associated with
> > each item that indicates if it is present. *Is it possible to have theitems
> > not present to be exported or listed on a different form or worksheet.- Hide quoted text -
>
> - Show quoted text -
Enter it in a module in VBE.
from excel push Alt+F11 then right click on your workbook on the left
side of the window and Insert/Module and paste that code in the screen
on the right with the module selected. after that, you should have a
macro by the name of "MOVETHEM" when you run that macro it will
perform the action