Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a List using a Form | Excel Discussion (Misc queries) | |||
Help creating a form that will pre-fill from another worksheet | Excel Programming | |||
creating form on worksheet | Excel Programming | |||
Creating a User Form to update a list | Excel Programming | |||
Creating a list box in a user form | Excel Programming |