Having Trouble Getting My Userform to Populate the Corresponding Excel Spreadsheet...
Hello:
My name is Mich and I'm new to the group and I'm having an issue wth a userform that I created that needs to feed data to an Excel spreadsheet within the same woorkbook.
I have a user form that requires our engineering team to submit to my department when they are changing a process router. I have the userform set up, and the code written (incorrectly obviously). What I need it to do is once the engineer enters the data and presses "OK" the form should take the fields and fill out the corresponding Tracking form, with the data from the userform. For some reason, I cannot get it to work.
(Ex. CCTC # should then be filled out into the CCTC # on the Tracking Form spreadsheet.)
Any help that can be given would be greatly appreciated. And if I've explained what I need, poorly, please let me know.
BTW, I am VERY new to VBA!
| Attachment | Size |
|---|---|
| CF-491 Document Contol Change Request Form, Rev 01.xlsm | 80.52 KB |
hi MichWe can definitely
hi Mich
We can definitely help make this work and I can see immediately a number of reports that you might want to produce. If the data is structured properly from the start, it will make reporting simple.
If you want to try to plumb this in yourself, take a look at this:
Share Trading System
If you'd like to spend time on building your business instead.
Request a Quote
Your company looks similar to one we recently helped.
Take a look at the Case Studies (case 3: Infrastructure Installation Company)
Rgds
Nick