Excel Help need

[pagaldeewani]

Is there a way to create record selector in excel. I haven’t worked on an advance level in excel; therefore, I would require all the help I can get. Please and thank you. I have created this financial statment which actually calculates the values for loan. However, since there will be several statments for different clients I want form kind of thing, which is in ms access, and I know for calculation purposes excel is better. Now, I am kind of stuck, I don’t want user to del the previous info to feed in the new one or copy paste the sheet into different sheets. Is there an easy solution to it? If so then how can I accomplish this goal.

[TofiBaba]

Re: Excel Help need

Why don't u create an Excel template. So anytime you need a new loan thingy u create it from this template and write some VBA so it would ask you the basic question at the time of creation and then voila!! The whole sheet is printed out.

PS: Sorry, I forgot to send you that spreadsheet last night.

[nos]

Re: Excel Help need

so basically you want to protect the spreedsheet?
Tools → Protection → Protect WorkSheet [et al]

Protecting a worksheet is not enough, you’ll have to protect the workbook as well cause if you don’t, anyone can delete the entire worksheet … na rahai gee bans, na bajay ge bansurie … so don’t forget to protect the workbook as well.

I think I answered you question … khair

[pagaldeewani]

Re: Excel Help need

@TofiBaba

Why don’t u create an Excel template. So anytime you need a new loan thingy u create it from this template and write some VBA so it would ask you the basic question at the time of creation and then voila!! The whole sheet is printed out.

PS: Sorry, I forgot to send you that spreadsheet last night.

Okay I did mention that I am a newbie at it, I am not very good at it. So go over slow and step by step with me. What kind of vba code, how exactly they will work, where are the events. I saved it as template, but its not different then before. Its giving me same info, same alignment.

[pagaldeewani]

Re: Excel Help need

nos read the question over again, I want this sheet to copy itself over, like ms access. When we create form we have a selector in the bottom of the form, pressing that take us to next record. I want to create something like that.

[TofiBaba]

Re: Excel Help need

• 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.

[nos]

Re: Excel Help need

^ uff … chamak raha hai jigar :roman: … shabbash

[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.