Excel Auto Due Drawn Sheet Problem

[AVG123]

Hello Friends...........

I am in a trouble in Excel Due Drawn sheet.........I manually create a Excel calculation sheet.........my sheet is working properly without any mistake.......but it is manually........i want to convert it in automatic calculation sheet......



Now i am explaining the problem Step by step

Step 1. I manually feed Rs. 8942 in BASIC PENSION column=8942
Step 2. Period I just mention "START MONTH BASIC PENSION=01.01.2014"
Step 3. Enter "LAST MONTH BASIC PENSION=30.06.2015"

after enter the values in Step 1 to Step 3, excel auto insert row from Step 2 (01.01.2014) to Step 3 (31.06.2015) with Step 1 "8942" (01.01.2014 TO 30.06.2015 )as mentioned in My Excel sheet (attached)

Step 4. Now it takes auto DR value from DR Rates which are mentioned in DR SHEET
01.01.2014 Example:- Basic Pension=8942, DP=0, Commutation=0, DR=roundup((Basic Pension + DP)*100/100,0)=8942
30.06.2015 Example:- Basic Pension=8942, DP=0, Commutation=0, DR=roundup((Basic Pension + DP)*113/100,0)=10105


and i am totally confused how to do? please help me
(Sheet Attached)

[FlameRetired]

I am not sure I understand. So I'll start here with this formula in G16:G33.

Please Login or Register  to view this content.

It will eliminate the need to manually type in the percentages.

But first the dates in DR SHEET are not actual dates. They are text and need to be converted. Select the entire range. Click on Data on the ribbon. Choose Text to Columns, fixed width and select Date when that window appears. The above formula will not work without those steps.