Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup Multiple
http://www.gssitaly.com/RATEDEF_29012004.ZIP
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 colum 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 wuold want to be make with a macro(?!) I explain for one cell, but the macro must run if in the value in th column J is balnk. EXPLAIN In the sheet ANAGRAFE cell I3 is 12.500,00, this data is created from vlookup in D3 from sheet GRADO, for example insert 1A. In K3 i insert the date of initialize a payment for example inser 27/02/2004 In cell E3 insert a quantity of years payment, insert 5 (is possible t 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 cell J3 this mode: Insert in A7 of sheet "60" (because the payment is in 60 month) th 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 an 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 o relative sheet) If you want delete my formulas in the various cloumn for you 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 -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum multiple vlookup returns across multiple columns | Excel Worksheet Functions | |||
Vlookup multiple criteria multiple occurrences sum values | Excel Worksheet Functions | |||
Vlookup with Multiple criteria and multiple sheets | Excel Worksheet Functions | |||
Vlookup for multiple criteria, multiple worksheets | Excel Worksheet Functions | |||
How do I use VLOOKUP to ref multiple workbooks with multiple tabs? | Excel Discussion (Misc queries) |