http://www.gssitaly.com/RATEDEF_29012004.ZIP%5B/url%5D
This is a system of pay rool.
Definition of columns an cells:
SHEET ANAGRAFE
A=ID
B=Name
C=Agency
D=Class of employee
E=How many year of the payment
F=Number of payemnt
H=interess
I=Amount
J=Residual Amount
K=init first payment
L=Next payment
M=Constant paymnet
N=Percentage of total payment
O=And payment
P3=Interess
R=Index for the relation in to sheets 12,24,36,48,60 (This column Autocompose in to refer paymnet)
SHEET GRADO
Grid refered for the Max amount to require.
SHEETS 12,24,36,48,60 Plain of payment (in month)
This cells is the same for every sheets
A7=Amount
A11=Number of payment
A9=Interess
SHEET RATE symply dbase of payment (non important for my problem)
PROBLEM:
Many part of this workbook is maked with a formulas but i m sure that i wuold want to be make with a macro(?!)
I explain for one cell, but the macro must run if in the value in the column I is balnk.
EXPLAIN
In the sheet ANAGRAFE cell I3 is 12.500,00, this data is created from a vlookup in D3 from sheet GRADO, for example insert 1A.
In K3 i insert the date of initialize a payment for example insert 27/02/2004
In cell E3 insert a quantity of years payment, insert 5 (is possible to insert only 1,2,3,4,5, in the cell F3 is present
a symple formulas to calculate the quantity of month)
This operation make a index code in R3 of sheet ANAGRAFE.
I could want calculate, with a macro, the residual payment in the cells J3 this mode:
Insert in A7 of sheet “60” (because the payment is in 60 month) the value in I3, in this mode the sheet
“60” autocalculate the plain for this amount.
After this operation find the relative value in column L of sheet “60” from a vlookup refered from the value in R3 of ANAGRAFE
(find form the column B:L of sheet “60” – column B is the index and column L is the result of residual amount – in this case is 12.500,00)
End the macro process when in the cells of cloumn I is blank.
Important is to make a vlookup after the data in I is inserted in A7 of relative sheet)
If you want delete my formulas in the various cloumn for your convenience.
The interess for all type of payment is fixed 1n 2,25%
Associate a little button to run the macro
If i dont be clear i m here! Tks for all.
