Hello,

I'm in the midst of creating a form using Visual Basic and I need assistance with a particular function. I'll attempt to explain as best I can.

The form is collecting data to place into two separate spreadsheets, herein referred to as Blue and Yellow. Most of the information contained in both the Blue and Yellow spreadsheets is the same, however, there are a few differences that require the data to be separated (i.e. customer, process, etc.). At the top of the form I have a radio button for the Blue, and a radio button for the Yellow spreadsheets that I want to use to direct the data into the chosen spreadsheet.

I assume this is possible... but I also assume it will take quite a bit of work. I have attached a copy of the file of the database for your review.

Thank you in advance.

Master Part Information List.xlsm