I've been searching for something specific that I was hoping that someone has already made, but I'm not finding what I need so I'm hoping that someone here will be able to help point me in the right direction.
I'm creating a make-shift CRM for my team that'll allow us to save all of our client information that we individually collect into a central database/excel wb. I have a macro that was created by someone on this forum (thanks arlu!) that will be pulling the data from multiple work sheets (1 per user on my team) into a centralized database.
What I'm looking for is a way to create a custom user form that'll allow me to enter in information designated to a specific cell. Right now, I have 28 columns that'll need to be tied into a text box on the user form. Only 3 boxes need to have data entered into them in order for the user form to accept their information and place it onto a work sheet. I'll also need a way access this data entry form from a work sheet relatively easily.
Thanks!
Bookmarks