Creating a list on a different worksheet/form
 

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.

Creating a list on a different worksheet/form
 

On Mar 24, 3:15*pm, Jeff Frazier <Jeff
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).Offse t(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"

Creating a list on a different worksheet/form
 

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.

Creating a list on a different worksheet/form
 

On Mar 24, 5:01*pm, Jeff Frazier
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 the items
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