I need a formula that will automatically generate a mutiple worksheets based on an accounts balance. I have created a workbook that is a getting out of debt budget plan. I manually copied the information to every worksheet until there was no more debt left. What I would like to do is input the inforamtion on a master worksheet and it will generate as many addtional worksheets as nessacery.
I hope this information is what you need.
Thanks
You can not do it by formulea but there is something called as ***-in you need to create add -in for this
I will suggest you that get a small program for doing this which will do all buisiness processing automatically will give you lots of benifits such as notification error catching and all.
If you need anything else,let me know.
Calculate the amount if you know the total and percentage
For example, if you purchase a computer for $800 and there is an 8.9% sales
tax, how much do you have to pay for the sales tax? In this example, you want to
find 8.9% of 800.
Example
The example may be easier to understand if you copy it to a blank
worksheet.
Dear Madiha35,
I would recommend the use of the Table Function in Excel.
Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.
Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.
Step 1: Enter your data into the worksheet.
Step 2: Create Table
Highlight the relevant data
On the insert tab, click on Table
Step 3: Verify Table range is correct, Click OK
Step 4: Select the cell you where you wish to Sum Data.
Click on Autosum.
Step 5: To Insert new data
Click on the sum row in the table, (Not the entire worksheet row)
Right click, Insert, Insert Table rows from above
Step 6: Enter new data in row
Step 7: Data is automatically calculated in formula.
167 views
Usually answered in minutes!
×