Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Lakeland, Florida, USA
    Thanked 0 Times in 0 Posts

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

    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

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts

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

    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts