Excel Help need

[pagaldeewani]

Re: Excel Help need

@TofiBaba

• Create a workbook with all the formulas in place, then as NOS suggested protect it and save it as a template.
• Then you need an ‘on open’ event when u open that workbook
• with msg box that accepts text and then populate the text in a specific cell on the worksheet
• put it under the “this workbook” section in the vba editor
  When the user opens the workbook they get a few questions that they answer and those numbers get filled into the worksheet and it does all the calculations and then u can print it or what not.

what if they want to see some previous record and they don’t have all the numbers in front of them, would they be able to search it? would it save it like access does on a table.