Extraction and printing of values from every 12th cell of row
Posted by John Davidson on January 17, 2001 2:59 PM
Here is my problem.
I am creating a financial analysis spreadsheet that will extract specific data from an amortization schedule into a table that I have created. This amortization data is contained in an amortization schedule that is on the same spreadsheet page as the table. The problem starts with a logical test to determine if it is correct to extract the first number from a column in the amortization schedule. If this logical test determines a "yes" result, then this first number will be extracted and printed in that "test" cell. Here now lies my problem. After printing the first number, I now need to extract a series of numbers from the same column in the amortization schedule and print them in a row of cells in the spreadsheet table. The numbers that need to be extracted from the amortization schedule column are located every 12th cell in that column.
Any ideas. I am stuck!!