Selecting row on one sheet and filling in data on (Excel 2000)

[kdatrio]

We are trying to have a workbook with three sheets in it. We want sheet1 to be a ledger book style of sheet with all the entries in it. We then want the user to click on one row and allow sheet2 to be filled in a report style with the data from the selected row. Is there a easy way to do this? Any help would be appreciated. Thank you in advance

[sdckapr]

You could do this without code of any sort.
You could add a combobox whihc grabs a list from the entries in Sheet 1 (ledger) and based on the item picked the "variable row" would be selected.

Then by using INDEX functions, you can create formulas in Sheet2 that grab that row from a cell and each of the "report style" items would just grab from a different column of data.

HTH,
Steve