+ Reply to Thread
Results 1 to 1 of 1

Saving selection from data validation list to table in different worksheet using VBA

  1. #1
    Registered User
    Join Date
    03-10-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    6

    Saving selection from data validation list to table in different worksheet using VBA

    Is it possible to save a selection from a data validation list into cells in a table on a different worksheet within the same workbook? The list corresponds to dates so if I go to a new date, the list clears out but I need it to save whatever was selected onto a different worksheet.

    I've attached a worksheet. Basically what I'm looking for is for, when you click the approve button and select yes, it clears the form but records selection from cell i19 in a separate table on sheet2.

    Thanks in advance!

    timetracking.xlsm
    Attached Files Attached Files
    Last edited by anonDymous; 03-13-2013 at 01:55 PM. Reason: attachment

+ 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