Have you done any work in setting up your workbook? If so, please attach a sample so we can work on solutions using your own data. Remember to remove/replace any sensitive info before uploading the file.
Have you done any work in setting up your workbook? If so, please attach a sample so we can work on solutions using your own data. Remember to remove/replace any sensitive info before uploading the file.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
Thanks,tuph.
In the attached file, The Report worksheet will be the data entry sheet; assume Column A to represent several data columns, here just labeled to represent same. The interval and Amount columns will have drop down data as shown in the same columns in the Calculations worksheet.
The calculations worksheet contains the column labels and the text and numerical data that I will use to calculate the Projecvted Annual dollar amount.
Column lengths will have room for 1000 entries.
This is what I have set up at present; I appreciate your offer to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks