Results 1 to 3 of 3

help required on retrieving saved record and populating cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-22-2006
    MS-Off Ver
    2010
    Posts
    201

    help required on retrieving saved record and populating cells

    hi all, i posted earlier but i think my example was maybe too complicated to follow.
    i am posting a smaller spreadsheet which i hope is easier to follow:

    The user enters their details in th DataSheet page range B2:B5 the fills in the boxes underneath.

    In this example, 2 records have been saved into the STORAGE sheet for 1/5/2012 and 1/7/2012.

    My question is. Can a macro be set that would allow the user to enter data into section B2:B5 of the datasheet page and then retrieve all the data for that record, if it exists in Storage. ie: if it exists then the cells in DataSheet would be populated with the data.

    Possible complicating factor is that B23 is a drop down menu. Other drop downs exist in the full version.

    hope this is achievable.

    many thanks in advance
    Tinkerbelle x
    Attached Files Attached Files

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