Allow multiple entries using same userform in excel 2013

[cherias]

Dear Experts,

Thanks for all your suggestions and inputs you have provided me for different queries I have posted on this forum. Request your help again for an enhancement feature, to include in my existing user form.

I have attached screen shot of user form, which is to input data for service requests. As per the current user form, under a service request ID we can input only single SITE CODE and related details. However, I am looking to enhance the user form, so that under the same service request ID, we can add multiple SITE CODE (dynamic) and then accordingly, update related details specific to that SITE CODE.

In the database sheet, the different SITE CODE's and related details should fall under the same Service Request ID.

However, I am wondering that with such feature, how the SEARCH functionality work in user form. Ideally, I searched with Service Request ID, it should display in list box, all SITE CODES added under it and if searched with SITE CODE, it should display details, specific to that SIDE CODE.

Please let me know, on how to add an attachment to this post, so I can post the screen of the user form, which may give you all a better pcture of the requirement.

Thanks a lot.

 

[Smitty]

Welcome to the Board!

Please let me know, on how to add an attachment to this post, so I can post the screen of the user form, which may give you all a better pcture of the requirement.

To post a shot of a User Form you'll need to use an image sharing site like PhotoBucket, then post the url here. E.G. [ url ] image url [ / url ] (no spaces).

If you want to paste a screen shot, then just follow the HTML Maker link in my sig.

 

[cherias]

Hello Smitty,

Thanks, I have uploaded the screenshot to PhotoBucket -

1)

 

[cherias]

Hello Smitty,

So as shown in the picture, under the same Service Request ID, there may be multiple Site Codes and with each Site Code, the related data for each field will also vary. So please help and suggest.

Thanks.