[RESOLVED] Excel - move, replace, and list data

Hi all,
I have developed a pension calculator in Excel, primarily for single users to use through a website. I have been asked to update it to allow multiple calculations to calculate figures for more than one person.
So I have devised a DATA sheet for the info to be updated manually, added the formulas to get the desired results. Now I need for a macro to shift the results to the RESULTS page, do the calc for the next row, shift these etc until we have results for all the rows.
If we can get away with not having a results page all the better, I thought it may be necessary tho. I have tried recording a couple of macros but my knowledge of excel haults around about the macro stage!!
Any help would be much much appreciated :thumb:

i looked at your sheets, i have not figured out what you want to do, i looked at you recorded macro, but that did not help either

most of that information would be considered confidential, so care needs to be taken with what is displayed

Hi Westconn, thanks for your comments. All of the information on the spreadsheet is ficticious, and the real data is used by organisations that would have access to it all anyway.
I realise my explanation was pretty poor - it is quite hard to explain something in words that relates to the actions!
Basically, I wish to use the information from the data sheet to populate the calculator, then to record the results back to the data sheet. This will allow one person to perform multiple quotations at the push of a button instead of filling in the calculator for each quotation.
Hope this makes more sense!
Thanks again,
Greg