View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris850 Chris850 is offline
external usenet poster
 
Posts: 1
Default drop boxes, entering input

I am trying to create a workbook where I use list boxes to select the year,
month, and salesperson, after the selections are made I enter the data in
specific cells. From there it will be put in differnt sheets and formula
throughout the workbook. The issue I am having is that when I select another
month, year, or salesperson and enter the data in the same cells all the
previous information is lost.

How do I get the data that I entered for January, 2005 for Mike to stay in
the appropriate cells. I would like to use the same cells to enter all the
data but it needs to stay where it is put throughout the workbook when
different criteria is selected in the listboxes.