Hello Excel Forum,
I'm hoping one of you may be able to point me in the right direction. I've created a spreadsheet (DataCollectionForm.xlsm) that is used for coding play interactions. I've got two buttons with corresponding macros that allow me to clear the form or transfer data from the worksheet "EA - CodingForm" to the data table "EA - DataTable". I'm hoping someone can assist me with the appropriate VBA code to recall/edit/update previously entered data. In cell B2, I have a dropdown that shows the study ID's that have been previously recorded. If you select a study ID, I'd like the rest of the corresponding data that was previously entered to populate on the "EA - CodingForm".
Any help would be greatly appreciated.
Cheers,
MileHigh_PhD
Bookmarks