+ Reply to Thread
Results 1 to 2 of 2

Dynamically view and alter records

  1. #1
    Registered User
    Join Date
    06-29-2005
    Posts
    12

    Dynamically view and alter records

    Hi,

    I have a list in a sheet called Base_Data, the length of which may change. There are 35 columns which will not change.

    Column C contains the name of a company. I want to be able to click on the name of this company and then be taken to my other sheet, called Summary_Sheet, which displays the 36 columns in a form like appearance.

    Then I need any changes that happen in the yellow boxes to be reflected in the previous sheet, Base_Data, when you click back to the Base_Data by a button. At this point I need the SUmmary_Sheet to be cleared of data and to be ready for another record to be processed in the same manor.

    I have attached my spreadsheet in a zip file.

    Any help would be gratefully received.

    Regards

    Tubbsy
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517
    The way you have proposed your requirements would mandate the use of VBA programming.

    However it may be possible to revise your requirements slightly to avoid this.

    In Summary_Sheet have a cell marked as Company Name,
    type in a company name to this cell and get EXCEL to check against the values in column C of Base_Data
    =MATCH(A1,BaseData!C:C,0)
    The number returned by MATCH() is the position of the company name in column C.
    By working relative to this position you should be able to find the rest of the data you want.
    (use the OFFSET() and/or the INDEX() functions)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1