View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
COM COM is offline
external usenet poster
 
Posts: 40
Default Arranging cells to create a database

Well that's a factor of your original data. Of course it can be worked around, by checking to see at what cell you are currently at, and then creating a new sheet for continuation, or by moving over to the next available column(s) and starting the data again at the top. Another is to split your data as it is being processed into some functional category, like by Calendar year, or Fiscal year, whichever/whatever you may desire. Creating a worksheet for each of those functional categories. This would be a more user functional database, so that the user could go to a particular year and see what was done, and your "searches" through your database would be faster, as you would realize that your O would be n, to find the last purchased item, where it would be 1 + m for a search given a particular date.