title: Excel vb project-best practice
body: <p>I'm not a vb developer neither so familiar with excel. Anyway i have a project to be done using MS Excel (cannot use access). 
  System is to provide a ratio analysis(ans some other analysis) of companies where data from an annual report need to entered to the system. Then based on several reports data I can derive graphs and all other information.</p>
  
  <p>My question
  Now I can store data in a single sheet like using is as as a database. it'll be like</p>
  
  <pre><code>CompanyName     Year     Data1     Data2    Data3...
  </code></pre>
  
  <p>Here the CompanyName can be duplicated as many Years data can be entered. If I use this method Each time I derive company data, I have to search for the relevant rows in the worksheet and keep lots of data in an array as I read through those rows and produce the final result.</p>
  
  <p>Or I can use separate worksheet for each company. Then I only have to search for the relevant sheet name and perform operations in that worksheet it self easily.</p>
  
  <p>So what is the best way to do this?
  Thanks</p>