View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
GTVT06 GTVT06 is offline
external usenet poster
 
Posts: 141
Default 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